Skip to content
Contact us
  • There are no suggestions because the search field is empty.

How to submit orders in bulk with a CSV spreadsheet

🧾 Getting Started with CSV Orders

Overview

You can utilize CustomCat’s state-of-the-art production facility no matter what eCommerce platform you use! This guide explains how to manually submit orders using our Order by CSV feature—ideal for stores without direct platform integration.

🛠️ Step 1: Set Up Your CSV Store

  1. Log in at app.customcat.com or create a CustomCat account.

  2. In the left navigation, click Connect Store > Create CSV Order.

  3. Enter a Store Name and Store URL, then click Connect.

    Note: This is for internal reference only. You can enter a placeholder URL.

  4. Go to Settings for your new store and complete:

    • Payment Information

    • Shipping Label Information

  5. Click Save Changes to activate CSV ordering.

📄 Step 2: Format Your CSV File

Your CSV file must follow specific formatting rules. If formatted correctly, your orders will import and map automatically—no manual mapping required.

✅ Required Columns

Column Description
OrderID Unique order reference. Use the same OrderID across multiple rows for multi-item orders.
Quantity Number of units for each line item.
ProductName Internal name (for your reference).
ProductId CustomCat catalog ID (e.g., G500, CANLA15). View Catalog
Color Exact catalog color (e.g., Black, White).
Size Valid options: One Size, XS–6XL. Use catalog names exactly.
DesignURL Direct, publicly accessible .PNG or .JPG URL. Avoid Google Drive.
ExactArtwork Set to TRUE or FALSE depending on design placement.
ShipToFirstName, ShipToLastName, ShipToAddress, ShipToAddress2, ShipToCity, ShipToZip, ShipToState, ShipToCountry, ShipToPhone, ShippingMethod, CustomerEmail Full shipping address is required. Validate via SmartyStreets.
 

🧩 Optional Columns

Column Description
LineItemID Required if the item has both front & back designs. Each item in the same order must have a unique LineItemID.
DesignPosition FRONT or BACK (defaults to FRONT). Required for Front + Back items. Do not use custom entries such as Left Chest.
PresetID Use to assign a CustomCat preset for artwork placement.
 

📥 CSV Templates

📤 Step 3: Upload & Map Your File

  1. From your Store Dashboard, click Import Orders.

  2. Upload your formatted CSV file.

  3. You’ll receive a summary indicating:

    • How many orders were imported

    • Any formatting or mapping issues

  4. If mapping is required:

    • Click Select/Remap Product/Color/Size

    • Choose products manually from the CustomCat catalog

  5. Once all items are successfully mapped, check the orders you want to submit and click Process Orders.

💡 After processing, your orders will appear under Processed Orders and you’ll be charged automatically.

💡 Tips & Tricks for CSV Success

Preserve Leading Zeros in ZIP Codes

  1. Highlight the ShipToZip column in your spreadsheet

  2. Right-click > Format Cells

  3. Under Number > Select Special > Zip Code

Note: If you reopen the file later, repeat this formatting to preserve leading zeros.

Hosting Design URLs

  • Use Amazon S3 or Google Cloud Storage

  • Dropbox URLs must end in ?dl=1

  • Do not use Google Drive

Artwork Placement and Presets

  • Use ExactArtwork = TRUE to preserve spacing inside your artboard

  • Use ExactArtwork = FALSE + PresetID to trim transparent space and align using system presets

  • Review CustomCat Art Guidelines for Exact Artwork dimensions

  • Review CustomCat Presets for using CustomCat preset design placements. 

🙌 You're All Set!

With your CSV store configured and files formatted properly, you can now efficiently place bulk orders without any store integration. If you run into issues, our support team is always here to help.

Happy Selling!