Stock levels rounding, or leave as a decimal

Stock levels rounding, or leave as a decimal

Avatar image
Jun 07, 2016
Shane wrote
At the moment when importing stock levels from a .xls file, if the stock has a decimal in it (eg. x.xx), the stock level in emagic defaults to 0.

It would be great if emagic would leave the stock levels as they appear in the .xls or at the very least round to the nearest whole number.

New
0 votes
Vote
Reply
7 Answers
Avatar image
Jun 08, 2016
Alex Pryshlivskiy agent wrote
Thanks for comment. Our QA dep. will have a look at this problem.
Avatar image
Jun 08, 2016
Alex Pryshlivskiy agent wrote
Small update according to your request:
During the import you'll get this message for your format - see screenshot.

To avoid this situation please use expression - replace([CSV_COL(100)],".",",")
Avatar image
Jun 08, 2016
Shane wrote
Thankyou for your reply Sergiy

Unfortunately this has not helped me but i feel we are on the right path

Thanks
Shane
Avatar image
Jun 09, 2016
Alex Pryshlivskiy agent wrote
I hope this article will help you - https://www.opencartmanager.com/useful-articles/tipstricks/expressions-as-unique-means-of-data-handling-right-in-the-course-of-opencart-import/
Avatar image
Jun 09, 2016
Shane wrote
Thank You for this. The product we were checking was showing 0.6 in stock, we have since discovered that the formula you gave us rounds all decimals down to the nearest whole number, (in this case 0) which made me think it wasn't working.

Although not ideal that formula will work for us, Thanks

Shane

Avatar image
Jun 10, 2016
Alex Pryshlivskiy agent wrote
Thanks for an update, Shane!
Have a nice weekend :-)
Jun 15, 2016
System wrote
Hello,

We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com

Maybe we are waiting for some information from your side? In this case please get back to us.

In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.

If you do not reply us back, the ticket will be automatically closed within 24 hours.

With kind regards,

The eMagicOne Administration Team