1. plugngeek
  2. RO CSVI
  3. Friday, 11 December 2020
  4.  Subscribe via email
Hi,

Is it possible to activate variant product without generate them manually ?

I can export j2store_variant_id and variant_id but i can import only j2store_variant. I tried like that but it is working at 50%:

Options are imported
Value are imported
Variants are not created (and SKU/Price/Quantity/etc)

In the past, j2store had a plugin for that, but it did not worked anymore (libraries are not updated).

Thank you
Attachments (1)
Accepted Answer
Accepted Answer Pending Moderation
Hello,
The patch for importing SKUs for variants is ready and attached with this post. Do the below steps to run import with new field.

1. load the attached patch file
2. Update available field. You will now see a new template field option_skus
3. Add the field option_skus to import template. Variants SKUs should be separated by #.
4. Remember that the first combination gets the first SKU, second combination gets second SKU and so on.
5. Run the import.

Sample import content to use option_skus field


sku,product_type,option_names,option_values,title,catid,option_skus
10001,variable,Size~Color,XL#L~Red#Green,sample product,2,100011#100012#100013#100014


Let me know on how the patch goes.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Accepted Answer Pending Moderation
Hello,
Variants are automatically generated only when the product_type is set to variable. Also you need Generate Variants field to be set to Yes in your J2Store Product import template on Options tab. See attached screenshot.

If you still have any problems post the import debug log along with sample import file to check. To get the debug log check How to collect debug information? document.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, 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
Hi,

You will find here 2 files, my csv is better today (learning curve :P) but I have this SKU problem :

CSV14TEST.csv : in the log I had one error " Skipped Annonce Missing required fields sku" : it is because the first line is not good - It was my original problem
CSV15TEST.csv : I removed the first line and import it again but the SKU is not good. J2store has the ID variant as SKU and not my SKU.
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
CSV14TEST.csv : in the log I had one error " Skipped Annonce Missing required fields sku" : it is because the first line is not good - It was my original problem

That is correct. SKU is empty in the first line, RO CSVI uses that as needed field for import. With this field RO CSVI checks if there is an existing row in database and if exists, updates the row else inserts a new row.

CSV15TEST.csv : I removed the first line and import it again but the SKU is not good. J2store has the ID variant as SKU and not my SKU.

Can you post a screenshot on the variant id and not SKU?

I am seeing another issue with the file. You have title as Bebydomon and category_path as digimon-cartes/digimon-ver1 for all the rows in import file. RO CSVI uses alias from title and category_path to select the existing row from Joomla articles(J2Store Product) row and since all the rows have the same alias and category_path, existing Joomla content is used. Each product should have its own title and category_path. You need to correct this in your file.
Kind regards,

Tharuna

=========================
If you use CSVI, 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
Hi.


thank you. When i have created the csv, i have done an export and try to do the same for new products in import. Classeur1test,csv is an export from 2 products:
yokomon : i have created it with j2store
bebydomon : i have created it with RO CSVI import
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Yes i see the point you are making with SKU as Variable_ID. As much as i remember with previous J2Store versions when you generate the variants, J2Store used to store SKUs as Variable_ID and that is the same concept we used with RO CSVI. RO CSVI generates the variants using the parent row option_names and option_values fields by creating combination of these values as variants(Same as when you click on Generate variants button in J2Store). So we are now thinking of adding a new field option_skus where you can set the SKU for the generated variants in import file. RO CSVI will then read these SKUs and use it instead of Variable_ID. You don't need multiple rows in import file in this case. I am working on this new feature and will send you the patch file when it is ready for testing.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hi,

Ok, i understand. I need only one line because NM#SP#MP#HP are generated with the first line.

I will wait for the SKU patch ! Thank you very much
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hi,

It is working perfectly ! Thank you very much.
  1. more than a month ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1


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