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.
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.
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!
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