Categories
View Replies (1)

Resolved need help for import (VM3.0.12)

  1. digi100
    digi100
  2. RO CSVI
  3. Saturday, 19 December 2015
  4.  Subscribe via email
Hi,
I have the following problem to import to Virtuemart:
I have to import more than 10.000 products. The new supplier provides a csv file to import all necessary data. Also they provide a csv file to update the stock each hour.
1. All products have a product no (sku)
2. Some products with variations (colour, size, etc.) have an additional sub product no
For example:
Product 1: has only a product no (sku) and has no variations
Product 2: has 5 times the same product no (sku) because of the variations and also 5 sub product nos
It would make sense to keep the product nos because it will be easier to order at the supplier with the same no.
Any idea how to import these products from example product 2?
My idea was to add the sub product no to the product no. But if I want to update the product stock level I do not know how to import the regulary updated csv file from the supplier. Is there any other feld I could use for the sub product no and how does csvi know to update in the right way?
Thanks in advance, Daniel
0
Responses (1)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Hi,
I have the following problem to import to Virtuemart:
I have to import more than 10.000 products. The new supplier provides a csv file to import all necessary data. Also they provide a csv file to update the stock each hour.
1. All products have a product no (sku)
2. Some products with variations (colour, size, etc.) have an additional sub product no
For example:
Product 1: has only a product no (sku) and has no variations
Product 2: has 5 times the same product no (sku) because of the variations and also 5 sub product nos
It would make sense to keep the product nos because it will be easier to order at the supplier with the same no.
Any idea how to import these products from example product 2?


You can use the field product_parent_sku to map the products with its sub product. For product 2 you can have sub product no as product_sku which is a unique field and the product_parent_sku as parent product no its been derived from.

My idea was to add the sub product no to the product no. But if I want to update the product stock level I do not know how to import the regulary updated csv file from the supplier. Is there any other feld I could use for the sub product no and how does csvi know to update in the right way?

Yes your idea is correct here. CSVI uses product_sku to update or insert a new product.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!