Bulk Order Import

Create Your CSV File

Start by opening Microsoft Excel or your preferred spreadsheet software. Your CSV file must contain the following columns in exact order:

  • Column A: SKU
  • Column B: Quantity
  • Column C: Delivery Date
  • Column D: Customer PO

Example CSV Content:

ABC123,5,25/02/2024,PO12345
XYZ789,10,25/02/2024,PO12345

Important Tips:

  • SKUs must match our system exactly
  • Quantities must be whole numbers
  • Delivery Date must be in DD/MM/YYYY format
  • Each product should be on its own row
  • Don’t include headers or extra columns

Save and Upload Your CSV

  1. Save your file as CSV format (Select “CSV (Comma delimited)” in Excel)
  2. Go to My Account → Bulk Orders in your dashboard
  3. Click “Choose File” and upload the CSV file into the upload area
  4. Click “Upload Order”

Important Notes:

  • Only one order can be uploaded at a time
  • Pre-orders are not supported with 12.5% discount. You’ll have to place your order manually for pre-orders
  • All items must have sufficient stock for the order to be approved. Our system will validate all out of stock items, and you can automatically remove all out of stock items using the purge feature.

Review Your Temporary Order

After upload, your order will appear in the “Recent Orders” section. You can:

  • View full order details
  • Export to CSV for your records
  • Remove out-of-stock items
  • Delete the order if changes are needed
  • Approve the order when ready

Final Steps

Once you approve the order:

  • A WooCommerce order will be created automatically
  • You’ll receive an order confirmation email
  • The temporary order will be removed from your dashboard
  • The order will be processed according to your delivery date

Remember:

  • Keep your CSV file for reference
  • Stock levels are checked at upload and approval
  • Orders can’t be modified after approval. You’ll need to delete and reupload