1. diegob
  2. RO CSVI
  3. Friday, 08 November 2019
  4.  Subscribe via email
Good morning,
I need you to help me set up an import of products to Virtuemart with variant custom fields and stock control.
The products in the database that I have to import are clothing with characteristics of size and color, normal, but you have to control both prices and stock of the various variations.
The structure of the products would be a main one and a variable number of derivatives, really in the BD of Virtuemart would be as many products as children have more the father product but the display would be a single card with the father product and custom fields pointing to size and color (changing photo, price, color and size).
Manually from Virtuemart I have no problem but to create an import template that loads the products and creates as many products as variants has creating a structure of father - son I have not done and that is why I need your help.
Thank you in advance.
Accepted Answer
Accepted Answer Pending Moderation
Hello,
I explain myself: The father has a SKU and the children also have their SKU (for my only one) so I don't see where I link the children with the ID of the father they belong to.

You need to have fields product_sku and product_parent_sku in your import file. product_sku will have the actual SKU of the product and product_parent_sku field is for the SKU of the parent. For parent product row product_parent_sku field will be empty. Let me know if you need any more clarification.

You can take a look at VirtueMart Products import document for other available fields.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # Permalink
Accepted Answer Pending Moderation
Hello,
The structure of the products would be a main one and a variable number of derivatives, really in the BD of Virtuemart would be as many products as children have more the father product but the display would be a single card with the father product and custom fields pointing to size and color (changing photo, price, color and size).

You can have this setup when parent product has a category and child products follows its parent category. So in your import file have category_path field set only for parent product and leave it blank for child product.

Manually from Virtuemart I have no problem but to create an import template that loads the products and creates as many products as variants has creating a structure of father - son I have not done and that is why I need your help.

Take a look at Product import with custom fields document to know how to import variants.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,
I understand what he's telling me, but I don't see how the father-son structure is created.
I explain myself: The father has a SKU and the children also have their SKU (for my only one) so I don't see where I link the children with the ID of the father they belong to.

Greetings,
  1. one week ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


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