First you will need to reach out to info@fulfillengine.com to request this feature.
Once approved, you will see the option for Import orders on the homepage under Orders. This is where you are able to import orders via CSV.
3PL Orders
This offering is specific to STAHLS' Fulfill Engine Seller Essential accounts on the Discount Tier 1 or Discount Tier 2 plan with pre-approval.
If you have orders that are not on-demand or offline orders, you do have the option to create a 3PL product within the store.
The CustomOrderId would be an external id for where you are getting orders from. If an order is comprised of multiple SKUs, then you'd have more than one row but the same CustomOrderId value, to say that they ship together.
We then pull the shipping address information from the first row of the order and ignore those values on the additional rows.
On-Demand Orders
To communicate the design, the most common method is to prebuild a product within an account to generate the design ID. This provides the file, size, and placement for production. If this is an existing store, the design ID will likely already be created.
The product ID and color must match what is shown within the Fulfill Engine catalog. The sizing format should be XS, S, M, L, XL, XXL etc.
You must select a single option when communicating the Product / Design within a CSV import. Although the design ID is most commonly used, you also have the option use a Campaign (Store) Product ID or an artwork URL.
Using a Campaign Product ID
This method is similar to the Design ID, in that you are using a prebuild product within a Fulfill Engine store. The option provides production with the Design ID as well as the product. You will still need to confirm the color and size.
It can be located at the end of the URL within the product view.
See below for Product / Design (option 2) for what headers are required.
Using an Artwork URL
This option exists for all on-demand methods except for Embroidery. To substitute the design ID, you must use the fields below, where the Artwork URL provides a print-ready image, sized appropriately.
- Artwork1_ArtworkFileUrl
- This must direct to a PNG formatted file
- Artwork1_MockupUrl
- Artwork1_PrintingMethod
- dtf, dtg, embroidery, engraving, heat_seal_patch, screen_printing, uv
- Artwork1_PrintLocation
- View approved values here
See below for Product / Design (option 3) for what headers are required.
Approved CSV Headers
| Address | ShippingAddress_Name, ShippingAddress_AddressLine1, ShippingAddress_AddressLine2, ShippingAddress_City, ShippingAddress_State, ShippingAddress_PostalCode, ShippingAddress_Country, ShippingAddress_Phone |
| Customer PO Optional |
CustomOrderId |
| Confirmation Optional |
CustomerEmailAddress, OrderConfirmationEmailAddress, ShipmentConfirmationEmailAddress |
| Product / Design (option 1) |
CatalogProductId OR GTIN, ProductColor, ProductSize, Quantity DesignId |
| Product / Design (option 2) |
ProductColor, ProductSize, Quantity CampaignProductId |
| Product / Design (option 3) |
CatalogProductId OR GTIN, ProductColor, ProductSize, Quantity Artwork1_ArtworkFileUrl, Artwork1_MockupUrl, Artwork1_PrintingMethod, Artwork1_PrintLocation |
| Product / Design (option 4) |
CatalogProductId OR GTIN, ProductSize, Quantity NoDecoration |
| Roster Fields (option 5) |
CatalogProductId OR GTIN, ProductColor, ProductSize, Quantity
Customization_RosterField_JerseyName , Customization_RosterField_Number , Customization_RosterField_Team |
| Production Optional |
Priority, Quality, ShipmentFulfillmentNotes |