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

1. Click on "Products" in the navigation menu.

2. Navigate to "Bulk Operations".

3. Select the offline shop under "Create Manual Orders".

4. Click on the "Export" button displayed as an icon and wait for the template to be generated.

5. 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.

1. Upload the edited template in the upload section under "Create Product Listings".

2. 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 Existing order ID XY001, the new upload does not accept order ID XY001 XY001 (line 1) and XY001 (line 2) will compile both listings into the order XY001 XY001 (line 1), line 2, line 30, and line 50 will compile the 4 listings into single order.	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	[phone]	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