Categories
View Replies (2)

Resolved Updating Prices in J2Store

  1. sandstorm871
    sandstorm871
  2. RO CSVI
  3. Thursday, 28 February 2019
  4.  Subscribe via email
I'm struggling to import & overwrite prices in a J2Store.
Products have 1 main price & 4 prices set to different user groups. We initially set these up using CSVI, but cant get a simple CSVi template to overwrite prices to work.

Using CSVi > J2store > Price
sku,regular_price,price, cusomer_group_name

I have set;
"Overwrite existing data": YES
"Skip New Items":NO

When I run this on a small test CSV, for 2 products I know exist, each have 4 prices set for different usergroups, I see the CSVi success screen showing that 8 products have had "Product price updated", but upon checking the products back end, nothing is updated?

Screenshots, sample CSV & log file attached

Joomla 3.9.3
PHP 7.2.15
J2 Store 3.3.6 Pro
CSVi 7.11.0
0
Responses (2)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Andy,
To update a price, you need to have your new prices in price_new field. That is missing in your import file and so nothing happened with prices. Add this field and try the import. If you still have issues, post the latest debug log to check.
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
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
That works correctly now, thanks for your fast response Tharuna, that really helps me out!

For clarification and anybody else looking at this for help;

Set Import Template > J2Store, Price
Overwrite: Yes, Skip New:No
Fields;
sku,regular_price, price_new,customer_group_name

When you run the import only existing products are overwritten, regular price will update with any amendments & using the "price_new" field, your usergroup specific prices are updated too.
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


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