price update with mass actions --> google products price 0 eur

  • Posts: 71
  • Thank you received: 1
7 years 8 months ago #263787

-- HikaShop version -- : 2.6.2
-- Joomla version -- : 3.6.3
-- PHP version -- : 7
-- Browser(s) name and version -- : chrome

Hey,

When I update the prices with a csv through mass actions the prices will be 0 in the hikashop google products plugin result. When I edit the price in hikashop manuel the prices will be updated. I don't see anything strange in the database.

Best regards,

RG

Last edit: 7 years 8 months ago by RG.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
7 years 8 months ago #263788

Hi,

If the prices display fine in Google products before the import and not after, it can only means that something is different with them in the database.
I can't see any other explanation.

Please Log in or Create an account to join the conversation.

  • Posts: 71
  • Thank you received: 1
7 years 8 months ago #263897

Can you test this in a test environment? Or tell me what query the plugin uses the narrow down this issue?

I have this with different price updates.
The price in the shop is ok. When I edit the price and put it the same value again it's ok. But then what's the point of update them with csv :)

The csv is like this.
price_value_with_tax;product_code
130;5425026281014
135;5425026281021


Best regards,

RG

Last edit: 7 years 8 months ago by RG.

Please Log in or Create an account to join the conversation.

  • Posts: 71
  • Thank you received: 1
7 years 8 months ago #263904

I have updated to 3.0 and have a new issue. I have put the column name product_code in gtin value but now the xml gives me
<g:gtin><![CDATA[ product_code ]]></g:gtin>

Best regards,

RG

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
7 years 8 months ago #263907

Hi,

As explained in that setting, you either need to enter a gtin that will be set for all the products, or the column name of a custom product field where you would enter the gtin for each product.
"product_code" is not the column_name of a custom field and thus is set for all the products like you can see.
If you want the product_code in your listing, you can have is as a mpn by turning on the setting "Add Product Code (mpn)"

Please Log in or Create an account to join the conversation.

  • Posts: 71
  • Thank you received: 1
7 years 8 months ago #264056

Ok that's working again. Can you test the 0 euro from the mass actions?

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
7 years 8 months ago #264058

Hi,

Then please provide a screenshot of your mass action settings.
Also, if you could provide a screenshot of the hikashop_price table content before and after so that we could see what change you get on your end that would help.

Please Log in or Create an account to join the conversation.

  • Posts: 7
  • Thank you received: 0
7 years 8 months ago #264100

I found it. When I update the price in the mass actions. It changed the price_min_quantity to 1.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
7 years 8 months ago #264102

Hi,

Great !
I see what is the problem then.
Change the code:

$data->elements[$id]->price_min_quantity = '1';
						if($nbPrices)
							$data->elements[$id]->price_min_quantity = $data->elements[$id]->price_min_quantity.str_repeat('|1',$nbPrices);
to:
$data->elements[$id]->price_min_quantity = '0';
						if($nbPrices)
							$data->elements[$id]->price_min_quantity = $data->elements[$id]->price_min_quantity.str_repeat('|0',$nbPrices);
in the file plugins/hikashop/massaction_product/massaction_product.php and that will fix the problem with the mass action import.

The following user(s) said Thank You: RG

Please Log in or Create an account to join the conversation.

Time to create page: 0.069 seconds
Powered by Kunena Forum