Resolved VirtueMart Categories and Product order import

Hello,

I followed instructions at this page http://csvimproved.com/support/import/203-virtuemart/971-virtuemart-categories-and-product-order-import , but I have a problem that I'm not able to solve: I do not want to override the category structure but I need a category path because each single product could change order according to categories

What is the issue you are having with your CSV file? At first glance your import file looks good to me. Can you explain more on the issue you have and also post the debug log of your import? To know on how to get the debug log, check the blue box on top of this page.

(i.e could have order 1 for category A and order 100 for Category B)

To have a product in multiple categories with different ordering you should be having your import file like

product_sku;category_path;product_ordering
product1;category_path1;1
product1;category_path2;100

Hello and thank you for your reply

I set my import file as you described

To have a product in multiple categories with different ordering you should be having your import file like
product_sku;category_path;product_ordering
product1;category_path1;1
product1;category_path2;100

To be more specific, let's say we have
product_sku category_path product_ordering
ONX1G3IDR;Acciao/Online/WC ;1
ONX530A ;Acciao/Online/WC;2
ONX53034A;Acciao/Online/WC;3
ONX53034A;Acciao/Online/Lavabo;1
(please refer to screen1 to see how it works in Virtuemart, please note that each product has more than 1 category assigned)



At the end of the import the result is that the product ordering is assigned but I do not want the products to loose category assignment, for example before importing product ONX53034A had category Acciaio, Online, WC, Lavabo and after importing it has Lavabo only, the same for the other 2 products: they passed from Acciaio, Online, WC to WC only (please refer to screen2)

What I would like to obtain is to add product_ordering but I do not want to change categories assignment

Thanks again for your help, Giovanna


log-csv-screen.zip

Hello Giovanna,

for example before importing product ONX53034A had category Acciaio, Online, WC, Lavabo and after importing it has Lavabo only, the same for the other 2 products: they passed from Acciaio, Online, WC to WC only (please refer to screen2)

Since in your import CSV you are assigning your product to category_path Acciao/Online/WC, the product is set to the last level category WC. If you want your product to be set to each level of the category then your import CSV will look as below. Note that each category is separated by | and that is how multiple categories are imported in CSVI.

product_sku;category_path;product_ordering
ONX1G3IDR;Acciao|Acciao/Online|Acciao/Online/WC;1
ONX530A ;Acciao|Acciao/Online|Acciao/Online/WC;2
ONX53034A;Acciao|Acciao/Online|Acciao/Online/WC|Acciao/Online/Lavabo;3

What I would like to obtain is to add product_ordering but I do not want to change categories assignment

Load the attached patch file from CSVI maintenance menu so you can import multiple ordering for multiple categories. To have multiple product ordering for multiple categories you also need to change your CSV to look like below. Note that even product_ordering field is separated by | symbol so each ordering value belongs to each category.

product_sku;category_path;product_ordering
ONX1G3IDR;Acciao|Acciao/Online|Acciao/Online/WC;1
ONX530A ;Acciao|Acciao/Online|Acciao/Online/WC;2
ONX53034A;Acciao|Acciao/Online|Acciao/Online/WC|Acciao/Online/Lavabo;3|1


patch_vm_2017_10_25.zip

Hello Tharuna,
Sorry for delay in answering but it took more time to arrange data as per your suggestions.
I'm attaching log file and data file and a screen shot as example.
As you can see only some products take produt ordering
Please let me know how to go on

Kind regards
giovanna forum.zip

Hello Giovanna,
I see an issue in your import file. Say for example the first row of your import file "ONX538SS;Acciaio|Acciaio/Online|Acciaio/Online/Lavabo;1", there are four categories you have as per category_path field but only one value for product_ordering. So the value 1 will be taken for the first category Acciaio and the rest of them will be ignored. You may need to add product_ordering for all the category paths you have in your import file.