Is it possible to import Customer Orders by CSV? I can't find this kind of import. I need to import all our daily or weekly sales of our online webshop.
Or is it possible to create it directly into the DB via an SQL query?
Thanks!
Jack
By: Support
Posted on: Jan 19 2022 at 04:48:26 AM
Sorry. t's not possible to import orders via CSV.
It would be possible to INSERT using SQL Queries. That's what MiniMRP is doing. But I fear it's not simple. A purchase order is not in ONE table. It's spread over a number of tables and there's no document I can give you that explains what tables to use. It's also not just a couple of INSERTs. There'd be quite a few SELECT look ups to gather the IDs for fields that are not directly included in the PO tables.
Maybe you could look in the database. Take a snapshot of all tables. Then use MiniMRP to create a new order and then compare what's changed.
But I'm sorry. I can't help you with that.
By: Jack
Posted on: Jan 19 2022 at 06:08:51 AM
Thanks for your quick reply! I'll take a look into SQL. If I find a way to do it, I'll report on this post to share the queries.
BTW, CSV import for Customer Orders would be a nice feature to be added in a future release.
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.
