Resolved Is it possible to auto-activate variable j2store products

Hi,

It is working perfectly ! Thank you very much.

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

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.

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

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.

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.

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.