1. amelcher
  2. RO CSVI
  3. Friday, 15 June 2018
  4.  Subscribe via email
Roland,

I haven't created a forum post in a long while (usually I find the answer I need in the forums or guides). I am trying to figure out how to import the product variants for J2store products without having to do a custom table import via csvi. How can I import the product variants (created for variable product type)? The variables aren't articles, but j2store specific i("children";) type items that are associated with the primary j2store product that is linked to the article?



BTW - I was the guy who was writing to Sander a couple days ago about how amazing this extension is... :)

Thanks,
Adam
Accepted Answer Pending Moderation
Hello Adam,
As of now we do not support variants import in J2Store. We are working on this and will send the patch to you to test when it is ready.
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
Accepted Answer Pending Moderation
Well, for the first time in 6 years, I finally found an issue I couldn't solve with csvi import... any idea on when you should have something to test?

Thanks,

Adam
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Adam,
We are developing this feature and you should be having the patch file in a day or two for testing.
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. # 3
Accepted Answer Pending Moderation
Awesome thank you! Also since you guys are in the same area, they also have an Advanced Variable product type as well that would really make my life easier since half my products are variable and the other half are advanced variable. I can send you over the advanced variable extension for testing if you need it. Thanks again and I look forward to testing it out.


Adam
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Adam,
The patch for variants import is ready and is attached with the post. The instructions of using the patch file and the format of CSV file are explained below.

1. Load the attached patch file as explained here.
2. Reset tasks and update available fields as explained here.
3. We have extended J2Store product import to generate variants for Variable product type. So create a J2Store product import template with needed fields.
4. In import template settings on Options tab, Generate variants to be set to Yes(By default it is set to Yes) for CSVI to automatically generate variants.
5. On the same options tab set Delete Variants to yes (By default it is set to Yes) if the variants already set for product to be deleted before adding new ones. Setting this to No will append the variants.
6. In your import file, for the parent product row for which variants to be generated add fields option_names, option_types, option_values. An example CSV content is given below

"alias","product_source","product_type","sku","title","option_names","option_types","option_values"
"parent-product","com_content","variable","parent product","Variable","Size~Color~Material","radio~select~select","XL#L~Green#Red#Blue~Cotton#Nylon"

7. Run the import.

Next step is to update the price and other fields for the variants
1. Create a J2Store Variant export template
2. Add the needed fields, sku is the required field for import so make sure that you add that in export.
3. Update the price in the export file for the variants.
4. Create a J2Store Variant import template.
5. Import the updated export file so variants are updated with price and other details.

Thats it :)

Test the patch and let me know on how it goes.

For Advanced Variable product type, Is this a 3rd party J2Store plugin?
You can send us the plugin and we will test and see what we can do out of it.

patch_j2store_2018_06_20.zip
Attachments (1)
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. # 5
  • Page :
  • 1


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