"CSV import issue with decimals" (#2597859) / KingsPlugins

2 Tickets 1

In-process started the conversation 6 years ago on November 11, 2020 at 6:04pm

Hi there,

I'm currently importing products via an import plugin called Product/Review CSV Import Export (from WebToffee), everything goes smoothly, but issues start happening when I try to import prices (either regular or sale) with decimals. Whole numbers are OK, but anything with decimals doesn't import (see images attached). I tried both text and number fields on the CSV but still doesn't work.

Woocommerce regular price imports correctly with both, whole numbers and decimals, so I guess it's more a B2Bking issue than an import plugin one.

Any idea?

Cheers!

2,762

KingsPlugins replied 6 years ago on November 12, 2020 at 3:39pm

Hi there,

Thank you for purchasing our plugin,

I think that the problem might be that you are using commas (,) instead of dots (.) for decimals. B2BKing uses a number field there instead of text, so I think that when the browser gets the data with commas, it sees it as invalid for a number field. Can you try the same with dots ?

I just ran a quick test with B2BKing's own import tool and it seems to confirm that. Import works with dots, but not commas.

Can you check?

Kind Regards,

Stefan