Error when (CSV) importing combinations quantities with ASM and Warehousing

[bcarron]

Hi guys,

 

I have been using the CSV import functionality to create a few hundred products and combinations on these products. Unfortunately, I can't update quantities on these products. Is it possible to directly update the quantity of a product's combination in a warehouse when using ASM? I am using PS 1.6.1.1.

 

When I try to import combinations with the quantity column as well as Advanced Stock Managment, Depends on stock and Warehouse I get the following error:

Property Stock->price_te is not valid
at line 909 in file classes/ObjectModel.php

If I remove the quantity column, everything is fine and the combinations are created. But then I have to update all the quantities by hand and it is very slow.

 

Thank you for your help

Edited July 25, 2016 by bcarron (see edit history)

[RogueWaveLimited]

Have you tried importing a CSV with only the id's & quantities after you do the product import?

 

Try it with one product and combos

[bcarron]

Hi Rogue, thank you for your reply. I am not sure I understand, but I have tried importing combinations with only product ref, combo ref, attribute and value (both mandatory field for combo import) and quantities. It works if the product don't use ASM but with ASM and warehouse, the csv imports correctly but the quantity in the warehouse is not updated. It also works if I set ASM in the CSV but disable the warehouse (Depends on stock set to 0). As long as I don't have ASM + Depends on Warehouse + Quantity + Warehouse in the CSV file, it get imported.

[RogueWaveLimited]

Bcarron,

 

I don't think that it can be done with standard PS. I have done this in the past for a PS store. I'm pretty sure that I can make it work for your store as well. 

 

The problem (as you might see it) is that I sell this as a subscription service with a daily update. The service is $25/month. If you are interested I can do a trial and if it does not work, (for one or two combos for example), then there is no charge.

 

Richard

Edited July 28, 2016 by RogueWaveLimited (see edit history)

[bcarron]

Thank you for the offer, but I am trying to use CSV import to avoid paying for other tools

[bcarron]

I have got it to work by adding a Wholesale Price column and setting it to 0.0001. It does not work with 0 for some reason...

 

A workaround I found, if you want to keep the wholesale prices to 0, is to import the combinations with the quantity and a price field set to 0.0001 and then reimport combinations but this time without the quantities and a price field of 0.

Edited September 1, 2016 by bcarron (see edit history)