Proposal summary
The proposal covers the scope of sending CSV files including Item Fulfillment details to Mintsoft.
Requirement
The requirement is to send the Item fulfillment details as a csv file to an specific email id. Then order importing will be performed in their end.
Our Solution
Solution #1
We will create a saved search to fetch all the IF details and will schedule it to send it to this specific email id once in every day.
It will consider the IFs that are created in that specific day that are in PICKED status.
For it to be working fine, we expect that the VAT number, EORI number, PID number, IOSS number can be hardcoded.
We can create an employee record with this specific email and add it in search
Solution #2
We will create a scheduled script that will picks up the Item fulfillments that are created on that day and are in PICKED status.
The script will run at the end of the day daily and send details to the email id
Field mapping
Please confirm the following field mapping.
| Mintsoft CSV Fields | NetSuite Fields |
| OrderNumber | Item Fulfillment Number – Internal ID |
| CompanyName | “Harbour Lifestyle” |
| Customer | Customer |
| Address1 | Shipping address 1 in IF |
| Address2 | Shipping address 2 in IF |
| Town | Shipping town in IF |
| PostCode | Shipping Zip code in IF |
| Country | Shipping Country in IF |
| Telephone | Shipping Phone in IF |
| Customer email | |
| Product | Item name |
| Quantity | Quantity ordered |
| Comments | Memo |
| ShippingMethod | Shipping method |
| VATNumber | “362 9732 72 ” |
| EORINumber | —— |
| PIDNumber | —— |
| IOSSNumber | —— |
Please confirm either one of the solutions and let us know.
Assumptions
- We assume that we can send the Item Fulfillment internal id as the order number. So that on updating the item fulfillment back it would be easy. Please confirm.
- We assume that always the company name will Harbour Lifestyle
- We assume that the VAT number will be always “362 9732 72 ”
- We assume that all these fields will be same for every Item fulfillments – EORI number, PID number, IOSS number. Please confirm If not we will not be able to use the search functionality.
- In search, we are only considering the items that have an amount greater than zero in the sales order linked with the respective Item fulfillment. If not components will also show up in the search results.
- We assume that the updating IF status and adding tracking numbers will be carried out by the Mintsoft team.
- We assume that we can create an employee record with this specific email and add it in search
Risks
- We assume that there won’t be any issues in fetching this IF details.