Public Ticket #3728759

Export tiered prices CSV with SKU instead of Product ID

Closed
Comments
12 Tickets 9
Julien started the conversation 2 years ago on September 20, 2024 at 9:57am

Hey support, 

i just encountered a problem when importing / exporting the price lists: namely, the exported CSV takes the product ID as the basis for matching, but that doesn't make much sense, because in another store a product with the same SKU can have a different product ID. so it would make much more sense to work on the basis of the SKU instead of the product ID - can you implement that?

2,762
KingsPlugins replied 2 years ago on September 23, 2024 at 12:25am

Hello Julien,

-> When using the B2BKing import, you can actually enter the SKU on the first column there, instead of the product ID. The importer will work with that as well and will match it to the correct product.

-> It is possible to import min / max / step settings! Please see: https://b2bkingplugin.com/docs/quantity-rules-min-max-step-on-product-page/#3-toc-title - this works using the WooCommerce products importer.

This importer is fully integrated with B2BKing and can also import B2B prices. In fact, it's more advanced than our plugin's importer with more options.

Let me know if you have any questions or anything I can do,

Kind regards,

Stefan

12 Tickets 9
Julien replied 2 years ago on February 20, 2025 at 1:59pm

hey guys. 

i have to follow up on this thread. 


How can i mass-import prices in a CSV list, if the price itself contains a comma? e.g. one article costs 0,40 € 

this has trown off all kinds of imports i tried to make and i cant find a workaround. can you help me? 

2,762
KingsPlugins replied 2 years ago on February 20, 2025 at 5:15pm

Hi again,

What are you using for that import, is it the WooCommerce Importer tool? or our plugin's own importer tool?

Normally it should work to either enter the price directly with a comma (e.g. 0,40), or to enter it with a dot (e.g. 0.40). One of those 2 should work. 

 

What are you using for the import, and what happens when you try to import it?

 

Kind regards,

Stefan

12 Tickets 9
Julien replied 2 years ago on February 21, 2025 at 8:57am

Hi Stefan, 


i totaly did not thought about using 0.50 instead of 0,50 because if i would enter 0.50 in the tierd pricing list in the product page it would return an error, but using the importer tool everything worked fine, thank you very much! :)

1

Sign In