Categories
View Replies (11)

Resolved IMPORT Problem with product_price

  1. codeingenia
    codeingenia
  2. RO CSVI
  3. Thursday, 04 February 2016
  4.  Subscribe via email
Joomla! 3.4.8
CVI PRO 6.5.0

Template fields (IMPORT):
product_sku
product_name
product_s_desc
product_desc
product_price
product_in_stock
category_path
file_title
file_url
published
file_url_thumb
custom_title
custom_value
product_gtin
product_override_price

When I import some products that already exists in my store product_price filed is not updated, but it is added as 2nd or 3rd prices of a product.

Another field that is not updated is file_url_thumb (product image). When I try to import and I want to update a product image, it happen that the image is added, while I want that image will be updated

In TEMPLATE SETTINGS is set YES in Overwrite existing data.

I found this code:

Query for ProductPrice

INSERT INTO `wer9i_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('9567','0','6','0','47','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')

While code should be UPDATE INTO
0
Responses (11)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
There is no specific change in code in 6.5.3 to say it is not working. I tested your site again with the product_sku you have mentioned that price is getting added. I can see price is getting added at first if that price is not present for given shopper group and then from then it is getting updated. Please note that code will check if the given price is present for given currency and for given shopper group. If not present it will do an insert first and then starts updating if price, currency and shopper group all condition matches.
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
codeingenia
codeingenia
Accepted Answer Pending Moderation
I updated csvi to 6.5.3

Now I am having problems with import prices:

Sometimes is added and sometimes is updated

I've lost a day with this problem

So I've attached 2 debug file: 1 when price is added and one when price is updated. The csv is the same and all products tested exists.

When price is added I used this csv template:

^product_sku^~^product_price^~^product_currency^~^shopper_group_name^~^price_quantity_start^~^price_quantity_end^~^product_price_new^
^8166810375355^~^5^~^EUR^~^COM_VIRTUEMART_SHOPPERGROUP_DEFAULT^~^0^~^0^~^5^


When price is updated this:

^product_sku^~^product_price^~^product_currency^~^shopper_group_name^~^price_quantity_start^~^price_quantity_end^~^product_price_new^
^8010510398636^~^12^~^EUR^~^COM_VIRTUEMART_SHOPPERGROUP_DEFAULT^~^0^~^0^~^12^

Something changed after csvi update. I recreated avaible fields after csvi update, then I started testing

I cannot understand why sometimes is added and sometimes is updated.

Template is AGGIORNA PREZZI.

Thanks
Attachments (2)
com_csvi.log.635_added.zip
com_csvi.log.634_updated.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
codeingenia
codeingenia
Accepted Answer Pending Moderation
Dear tharuna thanks for the reply. Now problem is solved. Great support

I'm opening a new post for another specific problem, please take a look.

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Yes i still see the price getting updated. I set a price with value 12 and then updated it to 15. You can check the site. Only thing i did with your template is that loading file from computer, Since i cant change values in file, given in the URL. Attaching the file i used for update

UpdAlbiPrices_custom.csv
Attachments (1)
UpdAlbiPrices_custom.csv
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. # 4
codeingenia
codeingenia
Accepted Answer Pending Moderation
Thanks for the reply. I've cecked your import process and I noticed that in the product details (virtuemart) there are multiple prices for the product (sku 8010510401329). (please see attachment)

So I've tried to remove all the prices and re-start the import with template AGGIORNA PREZZI.

The situation is the same: prices are added. The price will remain single and will be updated, not added.

Did you see in virtuemart product details before telling me that price is updated?

I'm trying to import with different shopper_group_name, but problem is still present.

I've tryed tried with "-default-", "*", "COM_VIRTUEMART_SHOPPERGROUP_DEFAULT" as you suggests, but prices continue to be added.

Please take a look at template AGGIORNA PREZZI, try to import and then ceck in the product details page in virtuemart
Attachments (1)
product_prices.jpg product_prices.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 5
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Your price is getting added because the shopper_group_name you have in your import file is not a valid one. I tested with your template with shopper group from your site and can see price getting updated.
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. # 6
codeingenia
codeingenia
Accepted Answer Pending Moderation
I'm trying to import using your sample template. I've only modified some options. prices cotinues to be added and not updated.
I've not cleaned all the prices from naintenance because I want first solve this import and after I will be able to clean prices and import all of its again.

So if I use "Skip new item" option to yes, I receive this error:
" Item 8010510401329 not added because ignore non-existing items enabled "

If I use same option to no, prices are added. (log attached)

So please try to use my template called AGGIORNA PREZZI (loading file from url called UpdAlbiPrices_custom.csv) and you will notice that prices are added for product with sku 8010510401329. You made me a template and it worked, but using my settings in this template prices are still added. Please ceck my template and try to import UpdAlbiPrices_custom.csv.

I'm interesting use that kind of template, so If will work it i will not have other needs.

I've enabled you admin credentials. Thanks
Attachments (1)
com_csvi.log.531.zip
  1. more than a month ago
  2. RO CSVI
  3. # 7
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
If you are looking at updating only product_price field, I have created an example price import template "Import product price" on your site and was able to add and update a price. I have attached the sample file i used for insert and update. If there is any specific shopper group name for which price has to be added, use it under shopper_group_name field else leave it empty. Also note that product_price field value will be inserted and to update price you need to use product_price_new field.

You can follow more in the documentation Import price import.

I would also suggest you to clean the prices via the maintenance menu and then do a new clean price import. Please note this cleaning will remove all the data from virtuemart price table.


ImportAlbi_price.csv
Attachments (1)
ImportAlbi_price.csv
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. # 8
codeingenia
codeingenia
Accepted Answer Pending Moderation
Thanks for the reply.

I've tried to follow your guide but price is ever added

https://www.csvimproved.com/support/import/203-virtuemart/909-product-price-import

I've created a template with only product_sku, product_price, shopper_group_name_price, shopper_group_name

If I do an export with this fields and try to import the same file price is ever added and not updated

I have also tried to use product_override_price but it add a price and not update

I've deleted product_currency from template fields because in your guide is written that is not required. When I've tried to export a product currency field was blank.

I also tried to follow another guide:

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

In that guide is talked about product_price_new field that is not present in my avaible fields. I also tried to update avaible fields but is still not avaible.

So now I've created two template. Please try to import with "IMPORTAZIONE ALBI w shoppergroup" TEMPLATE and you will notice that for the product with sku 8010510397431 price is not updated but added.

So how can we solve?
  1. more than a month ago
  2. RO CSVI
  3. # 9
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Looking into your log file, i see fields which are required for importing product_price are missing. Please check the documentation Import product price to know more on it. CSVI couldn't find the correct price for product because of the missing fields and so new rows are inserted on every 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. # 10
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you send us the debug log of the import and the CSV file used for 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. # 11
  • Page :
  • 1


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