Categories
View Replies (6)

Resolved Update 1 field of existing product (variant product - field quantity - j2store product import)

  1. plugngeek
    plugngeek
  2. RO CSVI
  3. Wednesday, 23 December 2020
  4.  Subscribe via email
To start, I read that:
https://rolandd.com/support/ro-csvi/j2store-import-variants-with-stock-quantity
https://rolandd.com/documentation/ro-csvi/j2store/j2store-product-import
https://rolandd.com/support/ro-csvi/is-it-possible-to-auto-activate-variable-j2store-products (mine)

I Tried to update quantity in my Variant products. To do that, I dont use variant but j2store Product with fields:

1 category_path
2 product_type
3 taxprofile_name
4 title
5 sku
6 quantity

(overwrite existing data: YES)

All my items exist in DB (i make them all with RO CSVI) and I want to update quantity only but I can't because I have this error: Skipped because "Product Alias already exists" : it is normal because products already are in DB.

I don't understand how to update only 1 field (quantity) of existing products (variant product, field quantity - import template: j2store product)

Thank you very much and merry christmas :)
.
Attachments (2)
SAMPLETESTING.csv
com_csvi.log.95.zip
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The patch file to support quantity field in J2Store Variant import is ready and is attached here. You need to

1. Load the attached patch file
2. Update available fields
3. Run import using J2Store Variant import template to update quantity of variants.

Note that with J2Store variant import you need to specify the parent product the variant belongs to. You need to use parent_product_title or parent_product_alias or parent_product_id field in your import file so RO CSVI can identify the parent product.

Test the patch and let me know.
Attachments (1)
patch_j2store_2020_12_28.zip
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. # Permalink
Responses (6)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The reason you see the message Product Alias already exists is because RO CSVI cannot find your existing product and the option to create a product for existing articles is set to no.

RO CSVI cannot find your product because you have told RO CSVI to find your products based on the quantity field. That is not going to work unfortunately. By default, the sku field is used to find a product as this is the unique identifier for a product. You have the SKU field in your import file, so let's use that.

You can edit your import template and go to the Options tab and set the option Update based on to sku. Run the import and see how it goes.
Kind regards,

RolandD

=========================
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
plugngeek
plugngeek
Accepted Answer Pending Moderation
Hi,

I tried it with "updated based on : sku" but quantities are not updated.
Attachments (1)
com_csvi.log.111.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
J2Store does not have a quantity field for variable parent product but quantity field is only on variants. So to update quantity you should be using J2Store variant import and not J2Store product import. I see that there is no quantity available field in J2Store variant import. I am adding the field and updating the variant import. I will send you the patch file for testing once 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. # 3
plugngeek
plugngeek
Accepted Answer Pending Moderation
It works!! Thank you very much. Will you update the j2store plugin ?
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Thank you for confirming the patch is working. This fix will be included in upcoming RO CSVI release.
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!