Wrong stock number

  • Resolved yellowcrab360

    (@yellowcrab360)


    5 years, 3 months ago

    Hi, for the new created product the stock amount is exported multiplicated 1M times (example: 2 is exported as 2.000.000)

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Shambix

    (@shambix)

    5 years, 3 months ago

    That may depend on your pc’s locale (how it interprets decimals and thousands – with , or .) and also how many decimals you set in Excel.

    Try to set the number cells as normal text, or change the number locale for this file only.

    You can provide a link to the site and processed csv so I can look at it (as a temporary pastebin).

    Thread Starter yellowcrab360

    (@yellowcrab360)

    5 years, 3 months ago

    Hi, thank you for the response. The problem happens with only some products, the others show the correct stock quantities. Here the link to get the excel file:
    https://pastebin.com/7UX5s7en

    • This reply was modified 5 years, 3 months ago by yellowcrab360.
    Thread Starter yellowcrab360

    (@yellowcrab360)

    5 years, 3 months ago

    `Found the problem. Seems that some of the product stocks quantity are exported as float number instead of digital. Then the excel locale is set to interpret dots as thousand separator.

    Plugin Author Shambix

    (@shambix)

    5 years, 3 months ago

    Numbers are exported as they are in the db, so it’s probably all to do with how your excel is setup, your locale and the cell format.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Wrong stock number’ is closed to new replies.