@extends('layouts.master') @section('page_title', 'Sale Guideline') @section('title', 'Sale Import Guideline') @section('main_item', 'Sale Guideline') @section('sub_item', 'Sale Guideline') @section('content')
Sale Template

Follow the instructions carefully before importing the file.

The columns of the files should be in the following order

Column No Column Name Instruction
1 Invoice No (Required) * Column title should be "invoice_no".
* Must Be Unique.
2 SKU (Required) * Column title should be "sku" & Should be valid product.
3 Customer Name * Column title should be "Customer_name".
* If not Found Crate A New Customer.
  (If not found, new customer with the given name above will be created.)
4 Landmark * Column title should be "address".
* Ex: no 12,straight line
  (If create a new customer , it s required.)
5 Customer Mobile * Column title should be "customer_mobile2".
*Secondry Number Of Customer.
  
6 Customer Mobile2 * Column title should be "customer_mobile2".
*Secondry Number Of Customer.
  
7 City (Required) * Column title should be "city".
* Name of the Customer's City.
8 Quantity (Required) * Column title should be "qty".
*If Empty Leave 0
9 Delivery Charge * Column title should be "delivery_charge".
* *If Empty Leave 0
10 Discount * Column title should be "discount ".
* Amount Of Discount
11 Payment Method * Column title should be "payment_method ".
* cash(Online) Or Cod
* card_machine(Card Machine)
* daraz(Daraz)
* mint_pay(Mint Pay)
* pay_here(Pay Here)
* koko(Koko)
12 Order Status * Column title should be "order_status ".
* pending ,confirm
13 Weight * Column title should be "weight ".
* Number Of Kilograms
14 Courier * Column title should be "courier ".
* Name Of Already Added Courier.
* Leave Empty For Default Courier.
15 Resources * Column title should be "resources ".
* Whats App ="1".
* Face Book Lead ="2".
* Face Book Massenger ="3".
* Bulk Order ="4".
* Daraz Order ="5".
* Voucher Order ="6".
* Tamil Order ="7".
* Follow Up ="8".
* Call Order ="9".
* Missed Call ="10".
* Flagship Store ="11".
* Meta ="12".
* Online ="13".
16 Gender * Column title should be "gender ".
* Name Of Already Added "Male".
* Name Of Already Added "Female".
17 Waybill Prefix * Column title should be "Waybill Prefix ".
* The Initial letter of the waybillnumber.
18 Waybill Number * Column title should be "Waybill Number ".
* Only the number related to the waybill
   number should be entered.
18 Waybill Postfix * Column title should be "Waybill Postfix ".
* The letter that follows thewaybill number.
19 Sale Note * Column title should be "Sale Note ".
20 Business Location * Column title should be "Business Location ".
* Full Name of the Business location Name.
21 Marketing Cost * Column title should be "Markating Cost ".
* Amount Of Markating Cost.
22 Order Batch * Column title should be "order_campagin_id ".
* Name of the Campagin ID.
@endsection