1. infogate
  2. RO CSVI
  3. Sunday, 11 October 2015
  4.  Subscribe via email
Everytime i import my products.cvs the products price is not updated but added to the products.

So when i open product page i see 4 or more same prices.
Accepted Answer Pending Moderation
Post the information requested at the top of the page under Looking for a useful answer.
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
Accepted Answer Pending Moderation
Ha RolandD,

De aanpassing van prijzen van producten van Virtuemart lukt niet zoals is aangegeven op het forum bij Import Virtuemart 2 prices onder "change a price". De velden zijn gebruikt zoals is aangegeven en het resultaat is dat er een record wordt toegevoegd aan de prijs van het product i.p.v. dat de prijs wordt aangepast. Ook zonder gebruik van het veld price_new is de uitwerking hetzelfde, nl een wordt een prijs toegevoegd aan het product. Hoe kan ik de prijs van een product wijzigen?

Joomla 3.4.4
Virtuemart 3.0.10
CSVI 6.2.0

http://www.csvimproved.com/en/support/import/203-virtuemart/912-import-virtuemart-2-prices

Met vriendelijke groet,

Marcel
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Post the information requested at the top of the page under Looking for a useful answer.


I will update my data too with mathm00 to see the problem. Prices won't update to existing product. The get added

Manufacturer translations Updated 2
Medias Updated 2
Product media relations Added 2
Product prices Added 2
Product translations Updated 2
Products Updated
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
@Marcel,

Please post in English as this is an English forum, it will allow other users to understand what is being talked about as well.

As for your price update, the import file is not enclosed, so I am going to guess a little.
SELECT `virtuemart_product_price_id` FROM `kls_virtuemart_product_prices` WHERE `virtuemart_product_id` = 104 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` IS NULL AND `product_currency` = 47 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'
SELECT `virtuemart_product_price_id` FROM `kls_virtuemart_product_prices` WHERE `virtuemart_product_id` = 104 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` IS NULL AND `product_currency` = 47 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'
SELECT `virtuemart_product_price_id` FROM `kls_virtuemart_product_prices` WHERE `virtuemart_product_id` = 104 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` IS NULL AND `product_currency` = 47 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'
These are the 3 tries where CSVI is looking for an existing price, they have a common theme, the shopper group ID is empty. The question is, what you have entered in your import file for the shopper group name?

@infogate
The article Marcel linked is when you use the Price import, you are using the product import, so you need to use other fields.
SELECT `virtuemart_product_price_id` FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = 219 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` IS NULL AND `product_currency` = 47 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'
Like Marcel you don't have a shopper group ID. I don't see this field in your file. So you need to add the field shopper_group_name_price and set it to * as this denotes Available for all.
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
Accepted Answer Pending Moderation
Ha RolandD,

In my Templates "Import Product Price" I used Component: Virtuemart and Operation: Price.
In the table "virtuemart_product_prices" is virtuemart_shoppergroup_id = 0 in every record. I've used "*" in the Import-file.

I used 3 testcases, these *.csv are:enclosed

......................................test2....test3.....test4
product_currency.................x..........x..........x
product_price......................x..........x..........x
product_sku........................x..........x..........x
shopper_group_id................x..........x..........x
product_price_new..............x..........x
price_quantity_start.............x
price_quantity_end..............x

I do not understand why you think I use product import. The name of the Template is "Import product price". Which fields I should use? Where can I find this?

Regards,

Marcel M.
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello Marcel,

I do not understand why you think I use product import.
You are not using the product import but the user infogate is.

Which fields I should use? Where can I find this?
It is in the documentation Import VirtueMart prices. There is a section called Change a price, this has the fields listed you need.

Post the debug log of your import so I can see what happens. Let me know which file you used for the import.
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
Accepted Answer Pending Moderation
Ha RonaldD,

The log-files are enclosed at reply #45739. I have the log-files related with the testcase-numbers, see below in the table:

......................................test2....test3.....test4
product_currency.................x..........x..........x
product_price......................x..........x..........x
product_sku........................x..........x..........x
shopper_group_id................x..........x..........x
product_price_new..............x..........x
price_quantity_start.............x
price_quantity_end..............x
Log-file: com_csvi_log.........53........52..........54

I used the fields at "Import Virtuemart 2 prices" section "change a price"!

In all the testcases is a price added (inserted) in stead of changed.

Kind regards,

Marcel M.
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Marcel,

I have identified the issue, the value of 0 is the same as false, so CSVI didn't check for the correct shopper group. Attached is a patch file you can load and that should fix your issue.

Let me know how it goes.
Attachments (1)
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. # 8
Accepted Answer Pending Moderation
Ha RolandD,

The patch installed. After the import is the price changed. The fix works. Thanks.

Kind regards,

Marcel M.
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello

I just found the time to test adding the shopper_group to my product import file but the prices kept added to product!

Next step was to add the patch rolandd added above and that did the magic. I uploaded my successful log and test import csv.

Thank you once again
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 10
  • Page :
  • 1


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