Public Ticket #2921035

!!!IMPORTANT!!! Can't edit prices after CSV export, edit and import!!!

Closed
Comments
3 Tickets 4
Gastro Zone Swiss started the conversation 5 years ago on November 21, 2021 at 11:09am

Hi Stefan,

I have some troubles with the CSV price list export and import after which I have very funny acting prices in the woocommerce.

1. By 1st export I got the database wrong because your database works with , and my computer with ;. This I solved by changing my pc setting. I am using other databases which has to be in the format with ;. Can you add a choice of the csv format to the download? But even the csv was wrong - not corectly display in the cells - I could see all the prices there.

b2bking_price_list.csv

2. After changing my system to be able to download the csv in the right format, I got the csv right but without the regular prices - b2bking_price_list(2).csv. I could see only the sale price. Then I filled up all the missing prices manually as I need them. and upload the csv back - b2bking_price_list(1).csv. But I couldn't see any change in the price. Not on the front nor the back end of the web. 

3. When I tried to edit the product I could see, that in the edit page the price is actually as uploaded but everywhere else is showing the old price. When I export the csv now it came out with the right prices I uploaded before - b2bking_price_list(3).csv

1706351215.png
8427777345.png
7207100368.png


4. After saving the edited product, the price in products back end page and also on the web changed again to different price, which I have no idea where it came from.

- can't replicate that now to show screen shots


I have tried to clear the cache with a Chrome extension Clear cache, I have checked for any cache plugins in my WP but I can't see any. To clear B2BKing cache I add one new Dynamic rule and saved it. I have used the demo and tried to export and import the price list csv and the price haven't changed neither. 

Any Idea what to do? I can't edit my prices anymore. 

To log in to my website back end use https://www.gastro-zone.ch/wp-admin/admin.php?page=b2bking_tools

I will have to add your IP address to the ftp so please share it with me in case you can't log in.

Your username is: B2BKing_support

Your password: I've sent an email with reset link 


Thank you!


Igor

2,762
KingsPlugins replied 5 years ago on November 28, 2021 at 5:13pm

Hi Igor,

I've run some tests on your site and this turned to be actually really complicated. I believe there was a price cache update in WooCommerce 5.8.0  / 5.9.0 and prices were just not updating via our import tool anymore. It was working in the backend but not in frontend.


I made an update to the plugin and now prices do update correctly in my tests. 

So I should open/ edit each product and save/ update?

Only for 1 product, any random product in the site - that should clear price caches.


I see that in your site for example I enter the price as 299, but it shows as 277

1602991830.png

I think this is because of the tax configuration because if I disable B2BKing it is the same.

Is that part of the issue you were describing?


3 Tickets 4
Gastro Zone Swiss replied 5 years ago on November 29, 2021 at 4:16pm

Hi Stefan


I have checked the prices and it seems that they are still not updating at the frontend. You can have a look for example at https://www.gastro-zone.ch/product/bohemia-crystal-weinglas-siesta-300-ml/. The entered price is 5.69 and the frontend price shows 5.71.

The Vase Lisboa is showing 139 chf and the same price is entered. So there is no issue for me. It is weird that you can see the price without the VAT even it says inclusive VAT. Your profile is made as B2C where should be shown the price inclusive VAT. In my profile it works fine.

Thanks

Best regards


Igor

2,762
KingsPlugins replied 5 years ago on November 29, 2021 at 10:21pm

I figured out why tax was like that - it was set based on the user's country and I had no country set in my profile. I set it now based on shop country, since you only sell in Switzerland.


When prices are not updating, what appears to be happening is that WooCommerce only updates the price if it detects there was a change. So if price is 5.69 and you click update and nothing happens it's because WooCommerce already has 5.69 in their ledger for some reason. But if you will set it to 5.68 first, that will work. Then you can switch it to 5.69.


The B2BKing Import tool should not have an issue with this any longer - prices should update immediately after import. I tried now and as soon as I see this message:

3457601142.png

I refresh the page and price has also changed in the product page:

6663839526.png

Subsequent changes in the product backend via Edit Product are also working in my tests.



3 Tickets 4
Gastro Zone Swiss replied 5 years ago on December 3, 2021 at 4:52pm

Hi Stefan


Thank you for the update. It seems working now. I downloaded and uploaded the price list and it is showing the right prices now.

Thanks again!

1
2,762
KingsPlugins replied 5 years ago on February 8, 2022 at 12:11am

Hi Igor,

The WooCommerce team forwarded an issue to me, and I recognized the site and username.

This is what I received:


"You are currently experiencing an issue where the regular prices (for users that are not logged in and have a special discount attached to their user role) are not being sent over to Google Listings and Ads properly. What you've noticed is that instead of the regular price for many of your products, the 10% discounted is being sent instead.

This is causing alerts in Google Merchant Center and many times, data needs to be rectified for the issue to be resolved.

I'm also attaching the following screenshots you sent to further illustrate the issue for WebWizards:

Product Settings on WooCommerce: https://d.pr/i/8MySWl

Google Merchant Center Issues:

https://d.pr/i/D51IW6 https://d.pr/i/7QtZMR https://d.pr/i/gVrcNS"

If the prices sent over to Google Listings are the discounted prices, I believe this is based on your prices as the ADMIN USER. I believe this can be resolved by simply making sure that your admin user is set as B2C in their user profile. I think what happens is that the listings / ads are syncing the price, and they are getting the price as it appears for your current user.


Kind regards,

Stefan

2,762
KingsPlugins replied 5 years ago on February 9, 2022 at 8:59pm

Hi Igor,

Sorry for the delay in getting back to you here,

I'd like to clarify the issue first, because I'm wondering whether I got this right. I assumed that the discount was only added to B2B users. Is that correct?

Or is the discount normally applied to B2C users as well? 


I guess what I'm asking is: is the problem that the feed is getting the B2B prices rather than the B2C prices? or is the problem that the feed is getting the discounted b2c price, whereas you want it to get the regular b2c price?

I hope that makes sense,



If the problem is that the feed gets B2B prices, changing the admin user, and refreshing the feed, should have resolved it. B2B prices are only ever set if the current user is a B2B user, so I don't see how it would be possible for the feed to get it otherwise.

Before the feed is refreshed, it would be important to clear all plugin caches -> ideally also go to any random b2bking product and update it, to clear b2bking internal caches.

Sign In