Magento – Getting To Grips With Spreadsheets

I think it’s worth pointing out to all Magento developers that learning the intricacies of the dataflow is unquestionably worthwhile. It allows you to load the spreadsheet full of simple products, including those that make up the configurable products and this is a massive time saver. One thing to remember is to configure the inventory on the spreadsheet. 1 normally means yes and 0 equals no. Make sure that you set the column that suggests that the user configures the inventory at a later date is set to ‘0′ for no, otheriwse your products will all import out of stock.

I’ll be putting some Magento tutorials up in the next few weeks, including more about the dataflow.