All Excel templates for importing
Import products
1. To import products via a file, go to Menu -> Orders -> Products-> click ”import”
2. “Download template” to fill it with your product data and upload it to Orderadmin
3. – Open the file, fill in the needed information, and Save. After that return to ОА and press ‘Browse file on your computer to upload. It will load the file, then click on ‘save‘.
| Field | Description | Required |
| ExtId | A product has it only when it is from an external source. It is unique and cannot be duplicated. | ❌ |
| Shop | Here must be the Shop ID (displayed in OA) | ✔ |
| Name | Name of the product | ✔ |
| Image | Copy a direct link (URL) of the image from the internet and paste it and it will be visible on the platform | ❌ |
| Article | It’s for convenience if needed. It is like a SKU code | ❌ |
| SKU | SKU barcode of the product | ❌ |
| Price | Price for the product | ❌ |
| Purchasing Price | Purchasing Price – purchasing price for the product | ❌ |
| Barcode | Barcode – /SKU/ (can set it later on receiving) must have a barcode to be easily found in the system | ❌ |
| Type | Type of the product – Simple / Grouped / Pallet | ✔ |
| Weight | Weight | ❌ |
| X, Y, Z | Dimensions | ❌ |
—————————————————————————
Import Orders
1. To import products via a file, go to Menu -> Orders -> Orders -> click ”import”
2. “Download template” to fill it with your product data and upload it to Orderadmin
3. – Open the file, fill in the needed information, and Save. After that return to ОА and press ‘Browse file on your computer to upload. It will load the file, then click on ‘save‘.
/single order/
/multiple orders/
| ExtID | ExtID is the id that is from the online platform that is imported. Here the ExtID has to be in two rows – for order and for product – and has to be the same extid for both. | ❌ |
| Name | the name of the recipient | ✔ |
| Phone | The recipient’s phone number. | ❌ |
| The recipient’s email address. | ❌ | |
| Warehouse | Warehouse identification number. | ✔ |
| Shop | the identification number of the store. | ✔ |
| Payment State | Payment status | ✔ |
| Postcode | Postal code | ✔ |
| Locality | Settlement | ✔ |
| Street | Street | ✔ |
| House | House number or street | ✔ |
| Sender | sender ID number (diplayed in OA) | ✔ |
| Rate | ID rate | ❌ |
| Service Point | officePickup ID | ❌ |
| Offer | product ID | ✔ |
| Name | name of product | ✔ |
| Price | price of product | ✔ |
| Count | Quantity | ✔ |
—————————————————————————
Import Shipments
| ExtID | ExtID is the id that is from the online platform that is imported. Here the ExtID has to be in two rows – for order and for product – and has to be the same extid for both. | ❌ |
| Name | the name of the recipient | ✔ |
| Phone | The recipient’s phone number. | ✔ |
| The recipient’s email address. | ❌ | |
| Postcode | Postal code | ✔ |
| recipient Locality | Settlement | ✔ |
| Street | Street | ✔ |
| House | House number or street | ✔ |
| Sender | sender ID number (diplayed in OA) | ✔ |
| Rate | ID rate | ❌ |
| Service Point | officePickup ID | ❌ |
| Offer | product ID | ✔ |
| number of places | in how many boxes is the order | ✔ |
| itemExtld | if it has this id, it should be filled in | ❌ |
| placeExtld | id of storage place | ✔ |
| Name | recipient name | ✔ |
| payment | ❌ |