Categories
View Replies (6)

Resolved Updating Virtuemart prices via import

  1. eclipse
    eclipse
  2. RO CSVI
  3. Tuesday, 27 February 2018
  4.  Subscribe via email
Hi, I am using CSVI Pro 7.4.1 with Joomla 3.8.5 and Virtuemart 3.2.12 and I am having trouble importing updated prices. I am trying to import an updated pricelist into Virtuemart from some Point of Sale software which has the product SKU and pre-tax price in it - but the prices may be different in both systems.

When I try and import the prices, it adds them as a new (second) price and doesn't replace the original price (these products only have a single price field). I can see in the documentation there is a price_delete field, but I cannot seem to get the import working no matter what I try. When I refer to the documentation at https://csvimproved.com/support/import/203-virtuemart/1553-virtuemart-prices-import you suggest using as an example to Update Prices:
"product_sku";"shopper_group_name";"product_currency";"price_quantity_start";"price_quantity_end";"product_price";"product_price_new" - I am stuck with log errors saying "Missing Fields" because I do not have a field for "product_price" as the website and POS software run as separate price lists.

Sorry I have tried to look for answers but I am just stuck now :( - can you please help point me in the right direction?
Thanks,
Aaron
0
Responses (6)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Aaron,
In the document you have pasted you can see the list of required fields, these fields are needed for CSVI to find the matching price for a product and update it. If these required field values don't match to the ones in database table, CSVI would insert a new price. What you can do is export these required fields using VirtueMart price export and add your new prices to product_price_new field in the exported file and import the file. This way CSVI will update your product prices with new price.
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
eclipse
eclipse
Accepted Answer Pending Moderation
Hi Tharuna,

Thanks for replying, I understand what you are saying, and this would be ideal if this wasn't a process that the shop owners need to perform often - daily at least. I was hoping to automate the import process as much as possible for the shop owners who have reasonable but limited computer skills.

The suggested process of exporting the web prices, then exporting POS prices, then adding web prices to the POS export and then importing is something I could do when required, but it would be less than ideal for them to have to do and I imagine too time consuming.

Is there any means of automating this process that you can suggest? Attached is an example POS exported file

Many thanks,
Aaron
Attachments (1)
WEB LIST EXPORT - Copy (2).csv
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Aaron,
Without required fields updating a price is not going to be possible. One option you can try is to create a override for your import and modify the checks in code to select a price and run the import.
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
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Aaron,

Instead of updating existing prices you should be able to overwrite existing prices. If you create a file with the product_sku and product_price field and import that with your VirtueMart Price import. That should overwrite the existing price if you only have 1 price. Can you give that a try?
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. # 4
eclipse
eclipse
Accepted Answer Pending Moderation
Hi Roland,

What you have said is so simple it was the first thing I tried, except it kept adding new prices so I had 2 prices for every product in the import list. After you suggested trying it again I looked at the prices in the product details, and also the database itself. The only difference in the imported price was the shopper group-I have 2 defaults (I am guessing because it has been updated since vm1) and the import defaults to group 2.

I had to I set the shoppergroup to a different default number (0 instead of 2) by adding a new field in the template, and it worked great. You have saved me a lot of time and frustration, thank you very much.

Tharuna, thanks for the advice too, and it is handy to know what you have said about templates if I ever need to use that method.

Cheers,
Aaron
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Aaron,

Having 2 different default shoppergroups will throw things off indeed. If you do not specify a shoppergroup in your import file, CSVI will find the default one and use that. Which explains why the prices kept adding.

You can add the different shoppgroup as default value in your template, so your users don't even have to use it in their files as well.

Glad to hear this got figured out :)
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. # 6
  • Page :
  • 1


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