Skip to main content

CSV Tool Details

The Fuel Team avatar
Written by The Fuel Team
Updated over 10 months ago

Firstly, please download the CSV template. Once you have downloaded the CSV file, use the chart below for a description of the columns.

Note:

  • The term "string" used below refers to a set of characters that can also contain spaces and numbers.

  • Be sure to review your products and orders in the Fuel app to ensure that they line up with your expectations. If they do not:

    • See this article to edit your existing Fuel product,

    • See this article to edit the products in an existing order, or

    • See this article to cancel a pending order.

    • See this article for a list of our error messages.

Column

Required

Description

Order Name

Yes.

  • String.

  • Unique.

  • The value that uniquely identifies an order for a given seller.

  • Examples: FUEL_01, EQ4932, #1843, ART#25494_d.

Shipping Address 1

Yes.

String.

Shipping Address 2

No.

  • String.

  • Complementary address line.

  • Example: Apt. 6B

Shipping City

Yes.

String.

Shipping State

Yes.

String.

Shipping Country Code

Yes.

  • String.

  • Examples: MX, US, AL, DZ, AS, BR.

Shipping Zip

Yes.

  • String.

  • Zip Code.

Shipping Phone

No.

  • String.

  • Phone number added to the shipping details to contact the customer.

Customer First Name

Yes.

String.

Customer Last Name

Yes.

String.

Customer Email

No.

String.

Item Quantity

Yes.

  • Number.

  • How many items of the same product included in the order.

Product ID

Yes.

  • String.

  • Fuel product identifier

  • Examples: gloss-poster, beverage-mug, mate-poster, i-phone-11-case, fruit-of-the-loom-ladies-hd-v-neck-t.

  • You can use Composed Product ID: productId|color|size. (Example: gildan-cotton-t-shirt|Black|2xl)

Color

  • Yes.

  • No, when using Composed Product ID.

  • String.

  • Examples: Cyber Pink, Royal, Sports Grey, Blue Spruce, Crimson, Lagoon Blue, Dark Grey Heather.

  • Note: Color must be a valid color available for the provided Product ID and the beginning of each word must be capitalized.

Size

  • Yes.

  • No, when using Composed Product ID.

  • String.

  • Examples: 11oz, 15oz, XS, M, L, XL, 2XL, 3XL, 11x17, 17x11, 36x24.

  • Note: The size must be a valid size available for the provided Product ID.

Product Title

Yes.

  • String.

  • The value is used to identify the product in the Fuel App easily.

Front Artwork

Yes.

  • URL or string.

  • Image to use in the front of the product.

  • Examples: https://mysaveddesigns.com/abc/exampledesign.png, dancing_cat.png

  • Note:
    ​
    The URL must be a PNG or JPEG.


    If using a direct image URL, the file must be public.
    ​
    If using an already uploaded design to the Fuel gallery, the value must match an existing image in the Design Gallery with the file extension.

Front Artwork Position

No.

  • The position where the artwork will be placed.

  • Default value when left blank: Center (top and center for DTG printing).

  • String.

  • Allowed values: C, LC, RC.

  • For Posters, Mugs, and Cases, this value is always C, even if something else is specified.

  • LC corresponds to the left-hand side of the product (as if you were wearing it, your left-hand side).

  • RC is the opposite.

Front Artwork Size

  • No.

  • Yes, when opting out of the default values for artwork positioning parameters.

  • Size of the width of the artwork.

  • Default value when left blank: the system will optimize image size to fit the printable area.

  • Number.

  • Height is scaled proportionally based on the aspect ratio of the artwork.

  • Examples: 5, 13, 50, 100, 2.

  • For apparel, this value is in inches.

  • For Posters, Mugs, and Cases, this value is in percentage from 1 to 100.

  • Reference for the maximum printable area

Front Artwork Vertical Offset

No.

  • Number.

  • How far from the top of the printable area will the artwork be placed (neck for apparel) relative to the center of the artwork.

  • For Posters, Mugs, and Cases, this value is in percentage, from 1 to 100. It is measured from the center of the artwork.

  • For apparel, this value is in inches.

Front Artwork Horizontal Offset

No.

  • Number.

  • How far to the left or the right is the artwork positioned relative to the center of the artwork.

  • Only Posters, Mugs, and Cases allow a horizontal offset.

  • This value must be in percentage, from 1 to 100.

Back Artwork

No.

  • URL or string.

  • Image to use in the back of the product.

  • Examples: https://mysaveddesigns.com/abc/exampledesign.png, dancing_cat.png

  • Note:
    ​
    The URL must be a PNG or JPEG.


    If using a direct image URL, the file must be public.
    ​
    If using an already uploaded design to the Fuel gallery, the value must match an existing image in the Design Gallery with the file extension.

  • Mugs, Posters, Cases, and Hats do NOT support a back artwork.

Back Artwork Position

No.

  • The position where the artwork will be placed.

  • Default value when left blank: Center (top and center for DTG printing).

  • String.

  • Allowed value: always C, even if something else is specified.

Back Artwork Size

  • No.

  • Yes, when opting out of the default values for artwork positioning parameters.

  • Size of the width of the artwork.

  • Default value when left blank: the system will optimize image size to fit the printable area.

  • Number.

  • Examples: 5, 13, 50, 100, 2.

  • For apparel, this value is in inches.

  • For Posters, Mugs, and Cases, this value is in percentage from 1 to 100.

  • Reference for the maximum printable area

Back Artwork Vertical Offset

No.

  • Number

  • How far from the top of the printable area will the artwork be placed (neck for apparel) relative to the center of the artwork.

  • For apparel, this value is in inches.

  • For Posters, Mugs, and Cases, this value is in percentage, from 1 to 100.

Back Artwork Horizontal Offset

No.

  • Number.

  • How far to the left or the right the artwork is positioned relative to the center of the artwork.

  • Only Posters, Mugs, and Cases allow a horizontal offset.

  • This value must be in percentage, from 1 to 100.

Use QuickShip

No.

  • True/False.

  • Leaving this blank will default the order to Standard Shipping.

  • Entering "True" in this column for a QuickShip ineligible order could potentially cause errors throughout the entire CSV file import process.

Example shirt order #1

Column

Required

Order Name

#TUTO_001

Shipping Address 1

123 Main Street

Shipping Address 2

Suite #2

Shipping City

San Francisco

Shipping State

CA

Shipping Country Code

US

Shipping Zip

94110

Shipping Phone

Customer First Name

Tom

Customer Last Name

Smith

Customer Email

tomsmith@gmail.com

Item Quantity

1

Product ID

gildan-cotton-tank-top

Color

White

Size

M

Product Title

TUTO_001 - Donut Madness Tank

Front Artwork

Donut Madness.png

Front Artwork Position

LC

Front Artwork Size

2.5

Front Artwork Vertical Offset

2

Front Artwork Horizontal Offset

Back Artwork

Back Artwork Position

Back Artwork Size

Back Artwork Vertical Offset

Back Artwork Horizontal Offset

The order will create the following product:

“A medium White Gildan Cotton Tank Top T-shirt with the Donut Madness artwork on the left-hand side of the product, with 2.5 in of width and 2 in from the neck”.

Example shirt order #2

Note: Moving forward, the examples will not include the customer information since it will be the same across all orders.

Column

Required

Order Name

#TUTO_002

Item Quantity

2

Product ID

gildan-ultra-cotton-t-shirt

Color

Carolina Blue

Size

S

Product Title

TUTO_002 - Gildan Ultra Cotton

Front Artwork

Donut Madness.png

Front Artwork Position

C

Front Artwork Size

5

Front Artwork Vertical Offset

3

Front Artwork Horizontal Offset

The data above will produce the following item.

“A small Carolina Blue Gildan Ultra Cotton T-shirt with the Donut Madness artwork in the center of the product, with 5 in of width and 3 in from the neck”.

Example hat order

Column

Required

Order Name

#TUTO_003

Item Quantity

2

Product ID

yupoong-adult-retro-trucker-cap

Color

Royal/White

Size

M

Product Title

TUTO_003 - Youpong Adult Retro Cap

Front Artwork

Donut Madness.png

Front Artwork Position

C

Front Artwork Size

2

Front Artwork Vertical Offset

0

Front Artwork Horizontal Offset

The data above will produce the following product.

“A medium Royal/White Yupoong Retro Trucker Cap with the Donut Madness artwork in the center of the product, with 2 in of width and 0 in from the top of the printable area”.

Example poster order #1

Column

Required

Order Name

#TUTO_005

Item Quantity

3

Product ID

gloss-poster

Color

White

Size

16x24

Product Title

TUTO_005 - Gloss Poster

Front Artwork

red_1200x1200.png

Front Artwork Position

C

Front Artwork Size

50

Front Artwork Vertical Offset

50

Front Artwork Horizontal Offset

50

The data above will produce the following product.

“A 16x24 White Gloss Poster with the red_1200x1200 artwork in the center of the product, with 8 in of width (50%) (height is scaled proportionally based on the aspect ratio of the artwork), 0 in from the top of the printable area”.

The order sets the horizontal and vertical offsets to 50%; the artwork is placed at the center of the poster. Remember, the horizontal and vertical offsets are relative to the center of the artwork.

And for width, as it was also set to 50%, it takes half of the printable area.

The height is scaled proportionally based on the width, and as it is a square, the height is the same as the width.

Example poster order #2

Column

Required

Order Name

#TUTO_003

Item Quantity

3

Product ID

gloss-poster

Color

White

Size

16x24

Product Title

TUTO_005_02 - Gloss Poster

Front Artwork

red_1200x1200.png

Front Artwork Position

C

Front Artwork Size

50

Front Artwork Vertical Offset

0

Front Artwork Horizontal Offset

0

The data above will produce the following product.

So, to place the image exactly in the top left section of the poster, we can set the offsets to 25%.

Example poster order #3

Column

Required

Order Name

#TUTO_005_2

Item Quantity

3

Product ID

gloss-poster

Color

White

Size

16x24

Product Title

TUTO-005_2 - Gloss Poster

Front Artwork

red_1200x1200.png

Front Artwork Position

C

Front Artwork Size

50

Front Artwork Vertical Offset

25

Front Artwork Horizontal Offset

25

The data above will produce the following product.

Bags

It behaves the same as apparel.

Phone Cases

It behaves the same as posters.

Mugs

Latest change on Mug artwork sizing when a 100% image size is requested:

  • Old version: 100% of width refers to both sides of the mug.

  • New version: 100% of width refers to only 1 side of the mug.

Image Autofit

Garment and Totes

Based on your image aspect ratio, there will be three scenarios:

  • Your image aspect ratio is equal to the product print area aspect ratio: The image will be sized so it perfectly fits the product design area.

  • Your image aspect ratio is greater than the product print area ratio: The image will be sized so its height is equal to the product print area height.

  • Your image aspect ratio is smaller than the product print area ratio: The image will be sized so its width is equal to the product print area width.

Other Product Categories

The image will be optimized for maximum coverage of the print area.

  • Bigger aspect ratio image:

  • Lower aspect ratio image:

Did this answer your question?