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.
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
Jun 08, 2016
Alex Pryshlivskiy
agent
wrote
Thanks for comment. Our QA dep. will have a look at this problem.
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)],".",",")
During the import you'll get this message for your format - see screenshot.
To avoid this situation please use expression - replace([CSV_COL(100)],".",",")
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
Unfortunately this has not helped me but i feel we are on the right path
Thanks
Shane
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/
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
Although not ideal that formula will work for us, Thanks
Shane
Jun 10, 2016
Alex Pryshlivskiy
agent
wrote
Thanks for an update, Shane!
Have a nice weekend :-)
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
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