How does everyone manage inventory in bulk?

[orcusomega]

I get a CSV feed from my supplier that has items (combinations) listed out each as on individual product - I would like to be able to manually create the master product and combinations, but use their feed to update all the inventory, prices etc based on the ID.

 

Currently when I go to update the inventory, it requres the name field, and that overwrites or creates new (duplicate) products. In order to do just-in-time inventory, I need to be able to update 2500 items daily in the most effecient way possible... I have already created a program (Excel macro, actually) that does all the data manipulation, I just need to figure out the PS side of things.

 

I am running 1.5.2 - I don't want to have to move to another ecommerce platform, I like PS, and I am sure there is something here I am missing

 

Thanks!

 

Bob

[benjamin utterback]

Hello orcusomega, because you have daily turn around numbers like this, I suggest that you use a Store Manager of some sort. You can try it Free here, http://www.prestasho...m/free-download

 

Also, there are module at the Add-On Store for quick, bulk mass edit, and csv functionality.. http://addons.prestashop.com/en/13-bulk-update-prestashop-modules

[orcusomega]

I am poking around with the Combinations import, and just want to be sure that I have the logic down.

 

Assume I have an item:

 

"Armband", with a product ID of "12"

Combination "Color:Orange" has an ID of 12-1

 

Just so I get this right, can you double check this logic?

 

Product ID*                            12 (ID of the main item, non-combination)
Attribute (Name:Type:Position)*        Color:Color:1
Value (Value:Position)*                Orange:1
Reference                            part number for ORANGE band)
EAN13    
UPC                                    Unique UPC for orange band
Wholesale price    1 dollar            (my cost)
Impact on price                        Increase/Decrease over price of main item
Ecotax    
Quantity                            QTY of this combination - as in 12 organge
Minimal quantity    
Impact on weight    
Default (0 = No, 1 = Yes)    
Image position    
Image URL    
Delete existing images
ID / Name of shop    

 

Is this correct?

 

Thanks!

Edited November 30, 2012 by orcusomega (see edit history)