Weight problem with decimals when importing via CSV

  • Resolved sign58

    (@sign58)


    1 year, 3 months ago

    Hi, I’m trying to import products into Woocommerce via CSV file exported from a Google Sheet, I found on https://woo.com/document/product-csv-importer-exporter/ the name of all the fields. I have a problem with the weight, if I import a value of a product that weighs 1.90 it is only 1, but if the value is less than 1 (for example 0.70) the imported value is zero. So it doesn’t take decimals into account. How can I solve this problem?
    Regards.

Viewing 1 replies (of 1 total)
  • Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @sign58

    This issue might be due to the format settings in your Google Sheets. When exporting your data, ensure that the cells containing the weight are formatted to display decimal places.

    To do this, select the cells, click “Format” in the top menu, then select “Number” and choose the decimal places you want to display. Once done, try exporting your file again and importing it into WooCommerce.

    Direct link: https://gifyu.com/image/SRSJF

    Let us know how that goes. Looking forward to helping you.

Viewing 1 replies (of 1 total)
  • The topic ‘Weight problem with decimals when importing via CSV’ is closed to new replies.