[Skip to main content](#vessel-content)

#   price update with mass actions --&gt; google products price 0 eur

##

- **[RG](/forum/user/39276-rg "View RG's Profile")**
- [![RG's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39276-rg "View RG's Profile") Topic Author
- [ Offline](/forum/user/39276-rg)

Less More

- Posts: 71
- Thank you received: 1
-
-

9 years 7 months ago -  9 years 7 months ago [\#263787](#263787) by [RG](/forum/user/39276-rg "View RG's Profile")  *[price update with mass actions --&gt; google products price 0 eur](/forum/30-integrations/889124-price-update-with-mass-actions-google-products-price-0-eur#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")* was created by *[RG](/forum/user/39276-rg "View RG's Profile")*

-- 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: 9 years 7 months ago by [RG](/forum/user/39276-rg "View RG's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy84ODkxMjQtcHJpY2UtdXBkYXRlLXdpdGgtbWFzcy1hY3Rpb25zLWdvb2dsZS1wcm9kdWN0cy1wcmljZS0wLWV1cj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14267
-
-

9 years 7 months ago [\#263788](#263788) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[price update with mass actions --&gt; google products price 0 eur](/forum/30-integrations/889124-price-update-with-mass-actions-google-products-price-0-eur#263788 "-- 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")*

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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy84ODkxMjQtcHJpY2UtdXBkYXRlLXdpdGgtbWFzcy1hY3Rpb25zLWdvb2dsZS1wcm9kdWN0cy1wcmljZS0wLWV1cj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[RG](/forum/user/39276-rg "View RG's Profile")**
- [![RG's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39276-rg "View RG's Profile") Topic Author
- [ Offline](/forum/user/39276-rg)

Less More

- Posts: 71
- Thank you received: 1
-
-

9 years 7 months ago -  9 years 7 months ago [\#263897](#263897) by [RG](/forum/user/39276-rg "View RG's Profile")  Replied by *[RG](/forum/user/39276-rg "View RG's Profile")* on topic *[price update with mass actions --&gt; google products price 0 eur](/forum/30-integrations/889124-price-update-with-mass-actions-google-products-price-0-eur#263897 "-- 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")*

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 ![:)](/media/kunena/emoticons/8.png ":)")

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

Best regards,

RG

Last edit: 9 years 7 months ago by [RG](/forum/user/39276-rg "View RG's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy84ODkxMjQtcHJpY2UtdXBkYXRlLXdpdGgtbWFzcy1hY3Rpb25zLWdvb2dsZS1wcm9kdWN0cy1wcmljZS0wLWV1cj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[RG](/forum/user/39276-rg "View RG's Profile")**
- [![RG's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39276-rg "View RG's Profile") Topic Author
- [ Offline](/forum/user/39276-rg)

Less More

- Posts: 71
- Thank you received: 1
-
-

9 years 7 months ago [\#263904](#263904) by [RG](/forum/user/39276-rg "View RG's Profile")  Replied by *[RG](/forum/user/39276-rg "View RG's Profile")* on topic *[price update with mass actions --&gt; google products price 0 eur](/forum/30-integrations/889124-price-update-with-mass-actions-google-products-price-0-eur#263904 "-- 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")*

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
&lt;g:gtin&gt;&lt;![CDATA[ product_code ]]&gt;&lt;/g:gtin&gt;

Best regards,

RG

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy84ODkxMjQtcHJpY2UtdXBkYXRlLXdpdGgtbWFzcy1hY3Rpb25zLWdvb2dsZS1wcm9kdWN0cy1wcmljZS0wLWV1cj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14267
-
-

9 years 7 months ago [\#263907](#263907) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[price update with mass actions --&gt; google products price 0 eur](/forum/30-integrations/889124-price-update-with-mass-actions-google-products-price-0-eur#263907 "-- 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")*

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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy84ODkxMjQtcHJpY2UtdXBkYXRlLXdpdGgtbWFzcy1hY3Rpb25zLWdvb2dsZS1wcm9kdWN0cy1wcmljZS0wLWV1cj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[RG](/forum/user/39276-rg "View RG's Profile")**
- [![RG's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39276-rg "View RG's Profile") Topic Author
- [ Offline](/forum/user/39276-rg)

Less More

- Posts: 71
- Thank you received: 1
-
-

9 years 7 months ago [\#264056](#264056) by [RG](/forum/user/39276-rg "View RG's Profile")  Replied by *[RG](/forum/user/39276-rg "View RG's Profile")* on topic *[price update with mass actions --&gt; google products price 0 eur](/forum/30-integrations/889124-price-update-with-mass-actions-google-products-price-0-eur#264056 "-- 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")*

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy84ODkxMjQtcHJpY2UtdXBkYXRlLXdpdGgtbWFzcy1hY3Rpb25zLWdvb2dsZS1wcm9kdWN0cy1wcmljZS0wLWV1cj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14267
-
-

9 years 7 months ago [\#264058](#264058) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[price update with mass actions --&gt; google products price 0 eur](/forum/30-integrations/889124-price-update-with-mass-actions-google-products-price-0-eur#264058 "-- 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")*

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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy84ODkxMjQtcHJpY2UtdXBkYXRlLXdpdGgtbWFzcy1hY3Rpb25zLWdvb2dsZS1wcm9kdWN0cy1wcmljZS0wLWV1cj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[riengenie](/forum/user/35344-riengenie "View riengenie's Profile")**
- [![riengenie's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35344-riengenie "View riengenie's Profile")
- [ Offline](/forum/user/35344-riengenie)

Less More

- Posts: 7
- Thank you received: 0
-
-

9 years 7 months ago [\#264100](#264100) by [riengenie](/forum/user/35344-riengenie "View riengenie's Profile")  Replied by *[riengenie](/forum/user/35344-riengenie "View riengenie's Profile")* on topic *[price update with mass actions --&gt; google products price 0 eur](/forum/30-integrations/889124-price-update-with-mass-actions-google-products-price-0-eur#264100 "-- 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")*

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy84ODkxMjQtcHJpY2UtdXBkYXRlLXdpdGgtbWFzcy1hY3Rpb25zLWdvb2dsZS1wcm9kdWN0cy1wcmljZS0wLWV1cj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14267
-
-

9 years 7 months ago [\#264102](#264102) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[price update with mass actions --&gt; google products price 0 eur](/forum/30-integrations/889124-price-update-with-mass-actions-google-products-price-0-eur#264102 "-- 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")*

Hi,

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

$data-&gt;elements[$id]-&gt;price_min_quantity = '1'; if($nbPrices) $data-&gt;elements[$id]-&gt;price_min_quantity = $data-&gt;elements[$id]-&gt;price_min_quantity.str_repeat('&#124;1',$nbPrices);

to: Code:

$data-&gt;elements[$id]-&gt;price_min_quantity = '0'; if($nbPrices) $data-&gt;elements[$id]-&gt;price_min_quantity = $data-&gt;elements[$id]-&gt;price_min_quantity.str_repeat('&#124;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](/forum/user/39276-rg "View RG's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy84ODkxMjQtcHJpY2UtdXBkYXRlLXdpdGgtbWFzcy1hY3Rpb25zLWdvb2dsZS1wcm9kdWN0cy1wcmljZS0wLWV1cj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop- Install &amp; Update- Product &amp; Category Display- Content Creation- Sales and Orders- - Orders management- - Reports &amp; Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import &amp; Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel &amp; Slider- - Mass Actions- - Filters &amp; Search- - Discount &amp; Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.256 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)

[](#top)
