Automated Order import functional scope
General overview of the feature and why we want it
We would need the functionality to be able to import orders both manually and automatically. The idea is to be able to create an FTP integration between two different WAPT instances.
User Interface
1. Import feed set up
Accounts mandatory and Tool Status not mandatory. Meaning account must be selected from the drop down while tool_status if not selected from the drop down MUST be mapped in the mapping screen.
Remove Tool_Status
2. Layout screen
Add all fields from tables orders, order_item, order_item_line and order_payment_details available for mapping.
Make field orders.marketplace_order_id to be mandatory. If nothing has been mapped for it then you don't allow the creation of the import.
Make field order_item.item_sku to be mandatory. If nothing has been mapped for it then you don't allow the creation of the import. Use it as key field for creation of both order_item and order_item_line records.
Make field orders.tool_status mandatory to be mapped on this step.
If orders.order_created_time has not been mapped then set up current date and time of the import.
Back end logic
When in the import file you have the following structure
| order id | order item sku | quantity | order item line |
|---|---|---|---|
| order1 | sku1 | 1 | 1 |
| order1 | sku2 | 2 | 2 |
| order1 | sku2 | 2 | 3 |
Must create 1 order with 2 SKU's and 3 order item lines.
Outstanding questions