Categories
View Replies (10)

Resolved Delete Prices on Import for specific shopper group

  1. atrus
    atrus
  2. RO CSVI
  3. Thursday, 19 May 2022
  4.  Subscribe via email
Hello all,

Very often we used the 'delete prices' option when importing prices or products, but due to the fact that we now have multiple prices (one per shopper group), it's not very useful anymore. The problem is for example that when we import prices for only one shopper group, all the shopper group prices are deleted also. Same when importing a price with a product, it will delete all other shopper group prices also.

We could use the update price feature, but it seems like that more work is needed every time, as you need to keep track of the old prices to be able to update them; not very failsafe also.

Perhaps the 'delete_prices' option could have a subsetting to delete only the prices of the particular shopper group the imported price belongs to? Something like overwriting.

Rgrds,
Chris
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Chris,
Please load the patch file sent in the thread here and check the price import again.
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 (10)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Chris,
Delete prices option is to delete all the existing prices of a product and import new prices. If you want to delete only specific prices of a product and for a particular shopper group you can use price_delete field with value set Y in import file. For the prices which should not be deleted leave this column empty. Set Delete prices option to No and use price_delete field in import.

Let me know if that helps.
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
atrus
atrus
Accepted Answer Pending Moderation
Thanks Tharuna,

price_delete sounds good when importing multiple prices. This field is not available though when you import a price through a product import; normally when we import a price through a product it is assigned to all groups (*) and that's fine. Is there any way when we update this product and its price (using the product import) to just update the price and not create a new one?

Rgrds,
Chris
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Chris,
price_delete sounds good when importing multiple prices. This field is not available though when you import a price through a product import;

Yes this field is available only with VirtueMart price import and not with product import.

Is there any way when we update this product and its price (using the product import) to just update the price and not create a new one?

If a product has single price then you can just have fields product_sku and product_price and update the price. But if you have multiple prices then we recommend to use VirtueMart price import template. In case of multiple prices you need to have few needed fields in import file and that is because RO CSVI selects the matching price row in database based on these needed fields and updates it. If the matching row is not found a new price row is created.
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
atrus
atrus
Accepted Answer Pending Moderation
Hi Tharuna,

Thanks for the explanation, ok i will have to stick to the mass price import for now then.

I run the attached template (tab price_import in the shared google sheet), but it was running forever, reached abt 8000 entries and i had to stop it, see attached the log also. Not sure if it indeed updated any prices also. Would appreciate your comments.

Regards,
Chris
Attachments (2)
csvi_templates_www.quality-tuning.eu_20220519.xml
com_csvi.log.181.zip
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Chris,
I run the attached template (tab price_import in the shared google sheet), but it was running forever, reached abt 8000 entries and i had to stop it, see attached the log also.

Please check Manage Timeouts document for import running forever. Check if changing the number of lines to import makes a difference.

Not sure if it indeed updated any prices also.

With price_delete field in import, RO CSVI only deletes the existing price. It does not update price. You need to run the import with new price without price_delete field. Can i ask if it is to update the price, why not use product_price_new field? With this field you need not delete a price but can update existing price. Please check VirtueMart price import document under Example fields to update price section.
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
atrus
atrus
Accepted Answer Pending Moderation
Thanks Tharuna,

I will check about the timeouts.

Our problem with product_price_new is that you need also to import product_price if i am not mistaken. However product_price is a very dynamic field, we update our website manually many times when we have limited products to update. So next time we make an import it will not be able to find the product_price for many products. Or perhaps product_price is not needed and product_price_new is enough along with shopper_group_name?

Regards,
Chris
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Chris,
Our problem with product_price_new is that you need also to import product_price if i am not mistaken.

Thats correct.

So next time we make an import it will not be able to find the product_price for many products. Or perhaps product_price is not needed and product_price_new is enough along with shopper_group_name?

product_price field is needed field, with that field RO CSVI can find the existing price row from database. Using product_prie_new field the new price is updated to selected row.
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. # 7
atrus
atrus
Accepted Answer Pending Moderation
Thanks Tharuna,

Price import is abit of a headache currently for us, but will see if we come up with a more manageable solution.

Tried to import some prices, but still something is off with the filters. Check attached template, (the google sheet is the one shared with you, so you can check the relevant sheet/filter). While the filter shows 1 product, when importing in CSVI it's not shown.

Chris
Attachments (1)
csvi_templates_www.quality-tuning.eu_20220523.xml
  1. more than a month ago
  2. RO CSVI
  3. # 8
atrus
atrus
Accepted Answer Pending Moderation
Thanks Tharuna, it works ok now :)
  1. more than a month ago
  2. RO CSVI
  3. # 9
  • Page :
  • 1


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