Bulk Create Manual Orders
This module is used to create orders not from the marketplace (offline orders). An offline store needs to be created to manage offline orders.
This module enables the creation of orders outside the marketplace, such as offline orders. To manage such orders, an offline store must be set up. Please contact https://support.sellercraft.co/ to request the creation of an offline store. Additionally, listings for the store must be created beforehand, and the Product Cloning module can be very helpful in this process.
Steps
Click on "Products" in the navigation menu.
Navigate to "Bulk Operations".
Select the offline shop under "Create Manual Orders".
Click on the "Export" button displayed as an icon and wait for the template to be generated.
Click on the "Template File" under the operation history once it has been generated to download the file. Edit the template file based on the specification
Ensure that all necessary requirements are accurate, and that the order being created does not already exist in Sellercraft.
In the second sheet, users can access the uploaded sample and search for the variant Seller SKU in the Variant Reference sheet.
Upload the edited template in the upload section under "Create Product Listings".
Uploaded file will be marked as "Processed" under operation history if no issues were encountered.
Template Specification
Shop ID | Order ID | Currency | Order Shipping Cost | Order Discount | Price Paid By Customer | Order Remarks | Order Date (DD/MM/YYYY) | Shipping First Name | Shipping Last Name | Shipping Phone | Shipping Address | Shipping Postal Code | Shipping Country Code | Billing First Name | Billing Last Name | Seller SKU | Fill up the quantity ordered. |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Mandatory | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory | Optional | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
Shop ID for this product. | Order ID for this product. | Shop Country currency | The shipping fees of the order | Discounted price must be lower than Full Price | The amont of the price paid by customer. | Any remarks of the order | The date of the order | The first name of the shipping | The last name of the shipping | The shipping phone number | The shipping address | The postal code of the address of the shipping | The code of the shipping country | The first name of the biller. | The last name of the biller. | SellerSKU is a unique identifier for each product variation. SellerSKU value cannot be duplicated in a shop/system. | The number of the total order |
Select from Dropdown list / Copy and paste the ID of the shop from the “Shop Reference” sheet. | Fill up the Order ID. This will be the identifier for orders so it should be unique. Mandatory
| Select the currency from the dropdown list or refer to Currency Reference Sheet for the correct value . | Fill up the order shipping cost - Listing level Data range: 0 and above | Fill up the order discount - Listing level Data range:0 and above. | Fill up the price paid by the customer .Total price paid by the customer excluding Order Shipping Cost. | Fill up the order remarks. | Fill up the order date with the correct format (DD/MM/YYYY). | Fill up the shipping first name. | Fill up the shipping last name. | Fill up the shipping phone | Fill up the shipping address | Fill up the shipping postal code | Fill up the shipping country code | Fill up the billing first name | Fill up the billing last name. | Fill up Seller SKU. Refer to the Variant Reference Sheet for the correct value. Must be existing Variant | Fill up the quantity ordered. |
3ca5f2a2-6098-46fe-b1c1-2ec0a976b5d5 | Gift_INV/20220926/MPL/2685403394 | MYR | 4.00 | 1 | 50.00 | Gift_INV/20220926/MPL/2685403394 | 27/09/2022 | Tommy | gunawan | +628112349788 | Jl. Sumber Nanjung, Kec. Babakan Ciparay, Kota Bandung, Jawa Barat, 40223 [Tokopedia Note: Jl. Sumber Nanjung No.19-2] | 40223 | ID | Tommy | gunawan | Wipes-Leather | 1 |
Sheets
Orders | This is the sheet where user inputs the data for new manual orders to be created |
Upload Sample | Refer this sheet for order sample |
Variant Reference | All existing SKUs (listing) in the account |
Currency Reference | For view only. |
Example
Last updated