Information management with WORDPRESS / PART II : bulk editing

While comparing wordpress woocommerce with magento, I pointed out the very efficient bulk editing feature for products in magento : it's quite amazing to find out that new versions of wordpress bring features you would not even imagine. Version 2.7 of wordpress, brought to the world in december 2008, brought the famous Batch and inline editing, also known as BULK EDITING. Our main interest of bulk editing in wordpress for information management is the bulk editing of tags and categories. Codex mentions fields that can be bulk edited.

Bulk Edit allows the fields, Author, Comments Allowed, Status, Pings Allowed, and Sticky, to be changed for all the selected Posts

Limitations : wordpress codex highlights the fact that Categories and Tags can be ADDED in bulk to a set of Posts, but it is not possible to CHANGE, or DELETE, a Category, or Tag, for those Posts.

the delete category feature is an important issue, as moving products, posts, or other elements does involve adding categories but obviously you'd need to remove categories from posts : this was the subject of a discussion topic on wordpress forum where some piece of code was posted : read Remove Categories with bulk edit to find this piece of code that could be transformed into a plugin or simply added to your theme.

Woocommerce extra bulk edit

woocommerce plugin is a perfect exemple of the extensibility of the bulk editing feature : price information (% increase or decrease), sale information,status, weight and stock information can be bulk edited. developers will find interesting coding information for adding extra fields to the bulk editing feature in woocommerce codebase.




Other extensions and plugins

for coders

for non coders

Magento and WordPress integration : custom connection solution

Wordpress has various mega menu possibilities that we integrated in magento

WordPress has various mega menu possibilities that we integrated in magento

Lately we were comparing   ecommerce solutions that we have experienced in various projects : Magento for big and expensive projects versus woocommerce for smaller projects that are bound to expand. A big advantage of wordpress is that it integrates powerful content management and powerful ecommerce solutions within the same platform. And in some cases, Magento solution for e-commerce integrated with wordpress for content management can be the very good solution that takes the best of both worlds.

Today we review solutions that allow reciprocal integration of data between wordpress and Magento.

Basic wordpress content into magento

installing magento extensions require some expertise but is worth the time spent. Integrating wordpress posts into magento pages is easy with the  Magento WordPress Integration extension that fits worpdress post list and content within magento templates.


Global WordPress Magento integration : custom solutions

  • First, you must consider installation on the same server, sharing stylesheets and body elements to have consistency across the whole site : before choosing magento template and wordpress theme, bear in mind that stylesheets and javascript from both themes will be shared.
  • Next step consists of taking wordpress theme elements and sending them to a cache folder for integration in to Magento. We propose to integrate following wordpress elements in Magento
    • Main wordpress menu integration into Magento
    • Widgets elements (footer, sidebar)
    • latest articles

Crud for code igniter

Code igniter is a popular php development framework that comes with basic functions for database management and is the basis foundation for a few projects that perform database records CRUD (create Read update Delete) functions

  • is a lightweight but efficient database CRUD solution, that offers a lot of useful implementations straight out of the box : 
    • flexi grid tables
    • automatic wysiwyg editor
    • ajax enabled swf file upload field
    • 1 to n and n to  n  relation ship
    • callback enables you to define extra behaviour for a lot of events : add record, modify, delete..

ATK framework : works with Zend

ATK is  a very professionnal database administration scaffolder : it has a full set of features, including relationnal records administration within tabs, hierarchical tree for hierachical data, n to n relationship, everything is coded via classes that define the , data table , the presentation mode, and its relationship with other tables. The great bonus of ATK is that is it not exclusive : one suggestion of the team is to use ATK for quick backend developpement  and Zend Framework for serious front end development.

Database comparison tools

After a few schema problmes on some obscure CMS installation, I decided to go for an automatic comparison of database schemas. Here is a list of tools you might try

Explaining database schema description formats

It is now common practise to use XML or YML (YAML) as convetionnal languages to describe SQL schema. This is particularly true within frameworks such as Symfony, propel, Doctrine , PhpOpenBiz. The advantages of using XML or YML to declare a DB schema include the automatic generation of SQL query codes and associated table relationship actions such as CASCADE Delete. The final objective obviously is to work with databases as easily as a few lines of generation directives, a process that is used to  develops browser based   CRUD (Create Read Update Delete) applications.

More on live grids : DHTMLXGRID

We 've covered Jquery, extjs and DOJO 's grid : even though they all cover a gerat amount of features, none of them opensource celebrities can compete with chaklf GPL half commercial DHTMLXGRID, that delivers all features you can expect from a modern HTML AJAX powered Grid : buffered data (unlimited scrolling), editable fields with rich in-cell editing, fixed multiline headers/footers, resizable, sortable and draggable columns, built-in filtering, searching and grouping capabilities. Numerous event handlers let you add necessary interactivity to grid-based interfaces .The only drawback to relying on such vendors is that one day -it's probably a matter of weeks- the opensource geeks will be up to date, including many more functions and compatibility guarantees. In the meanwhile, if you can't afford to wait, go for DHTMLXGRID with GPL license. If you plan to switch technologies, make sure your server side data delivery complies to standards datasources supported by most javascript grids, such as XML or JSON.

Ajax based universal data manager

Ever been through the nightmare of planning to unify all data sources your business is dealing with ? Ever thought of what could happen to sensitive data when you're travelling all around the world, physically or virtually, aggregating experience and datasources from all over the place  ? Seems that web based content and data managment is a must these days, and it pays to look at ajax based software from California based Informatica, which develops its application on the basis of SmartClient library. SmartClient library is part commercial, part GPL  : you can download client side libraries and develop your own modules to serve data to JSON, XML, or whatever data format you can handle to provide. PowerCenter, that's the name you want to remember when searching for data unification and centralization, accessible anywhere. Migration, synchronisation, warehousing are common tasks accomplished by PowerCenter Enterprise Platform, for which the AJAX based client side we could experience is only the visible part of the infrastructure iceberg it aims to support.

Read more

Content Manager from Webgate anywhere

A lot of nice names for this commercial J2EE based content management system that demonstrates extensive use of best dynamic HTML practice, with the help of the very special extJS library. The problem with that demonstration is that it will take you a while before you can test it on your development servers as you will have to go through commercial business AND serious java expertise in collaboration with Innovation Gate, the german company that develops this system. But it's worth the try : this CMS goes further than basic content and workflow management : cross browser is not enough, WGA is also "cross client" : Browser (IE and Mozilla), Lotus Notes, MSWord, HTML- and XML-Editors or Email are acceptable platform to work with the system that allows publishing content to any media : Web, Cell phone, PDA, pdf. Finally, WGA allows to integrate any data source and to deal with it as "virtual repositories". Invoices from SAP, business cases from CRM, data sheets from relational databases - all "business objects" are treated as content, just as if they were Web content maintained by authors.

Flexigrid : inside the next data browser

Advanced DHTML / javascript grid layouts have been around for a while : OpenRico's livegrid  has been available for years, and last february a new version of EXTJS' grid came out (UPDATE : EXTJS is about to relaease a new version of its editable GRID) . Well it's good news that Jquery javascript library should now be able to provide its own implentation of a data grid, with many features that any good data master should expect...

Read more

drag & drop tree

Drag and Drop Tree Component . Allows dragging of nodes within a tree, dragging external objects to a tree, and dragging nodes to a custom trash object, re-ordering nodes with drag & drop, populating the tree from an xml document, retrieving an xml string representing the tree