Hi Guys,
My client is using J2store with Variant products and we would like to be able to export stock levels. There does not seem to be a field available to export this.
Is it possible to create an export of all products including variants showing the stock of each and every product and variation?
Regards
D
- Dtorr1981
- RO CSVI
- Thursday, 20 December 2018
- Subscribe via email
0
Accepted Answer
Pending Moderation
Hello,
In CSVI J2Store Product export we have set grouping by product_id as default and so only the main products and simple products values are exported and not the variants. Please load the attached patch file and run your export.
Are you sure there are values for quantity field? CSVI does not do any manipulation with this field on export other than reading value from database and export it.
Try J2Store product export after applying the patch file to get the variant values on export.
patch_j2store_2018_12_24.zip
I have uploaded the patch file and updated the available fields however the stock is only exported for simple products not variable products. I selected every field for the export just to make sure and you will see the quantity field is empty for variable products. File Inventory(2).
In CSVI J2Store Product export we have set grouping by product_id as default and so only the main products and simple products values are exported and not the variants. Please load the attached patch file and run your export.
I then did another export by changing the export from Product to Variants and again, exported all of the fields - The quantity field in this export only contains a 0 or a 1 when the actual quantities are variable. File Inventory (3).
Are you sure there are values for quantity field? CSVI does not do any manipulation with this field on export other than reading value from database and export it.
Is there anyway just to get an export which contains the Product Name with each variant on a new line alongside how many are in stock?
Try J2Store product export after applying the patch file to get the variant values on export.
patch_j2store_2018_12_24.zip
Attachments (1)
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Thank you 
Unfortunately this has not solved the problem.
I have uploaded the patch file and updated the available fields however the stock is only exported for simple products not variable products. I selected every field for the export just to make sure and you will see the quantity field is empty for variable products. File Inventory(2).
I then did another export by changing the export from Product to Variants and again, exported all of the fields - The quantity field in this export only contains a 0 or a 1 when the actual quantities are variable. File Inventory (3).
Is there anyway just to get an export which contains the Product Name with each variant on a new line alongside how many are in stock?
Inventory (2).csv Inventory (3).csv

Unfortunately this has not solved the problem.
I have uploaded the patch file and updated the available fields however the stock is only exported for simple products not variable products. I selected every field for the export just to make sure and you will see the quantity field is empty for variable products. File Inventory(2).
I then did another export by changing the export from Product to Variants and again, exported all of the fields - The quantity field in this export only contains a 0 or a 1 when the actual quantities are variable. File Inventory (3).
Is there anyway just to get an export which contains the Product Name with each variant on a new line alongside how many are in stock?
Inventory (2).csv Inventory (3).csv
Attachments (2)
Accepted Answer
Pending Moderation
Hello,
The fields to export product stock was missing in J2Store Product export. I have added them with the attached patch file. Load the patch file, update your available fields and then check your export.
patch_j2store_2018_12_21.zip
The fields to export product stock was missing in J2Store Product export. I have added them with the attached patch file. Load the patch file, update your available fields and then check your export.
patch_j2store_2018_12_21.zip
Attachments (1)
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »