CSV Tool Details

Once you have downloaded the CSV file, use the chart below for a description for 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 order in the Fuel app to ensure that it lines up with your expectations. If it does 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 include 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.
Color	Yes.	String Fuel inventory checker 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.	String Examples: 11oz, 15oz, XS, M, L, XL, 11x17, 17x11, 36x24. Note: Size must be a valid size available for the provided Product ID.
Product Title	Yes.	String The value used to identify the product in the Fuel App easily.
Front Artwork	Yes.	String Image to use in the front of the product. Examples: cat.png, typing_cat.jpg, dancing_dragon.png, awesomedesign.jpg. Note: The value must match an existing image in the Design Gallery with the file extension.
Front Artwork Position	Yes.	String The position where the artwork will be placed. 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 the opposite.
Front Artwork Size	Yes.	Number Size of the width of the artwork. 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	Yes.	Number. How far from the top of the printable area will the artwork be placed (neck for apparel). 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	Yes, for Posters, Mugs, and Cases. No for apparel.	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.	String Image to use in the back of the product. Examples: cat.png, typing_cat.jpg, dancing_dragon.png, awesomedesign.jpg. Note: 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. Yes, if Back Artwork is provided.	String The position where the artwork will be placed. 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 the opposite.
Back Artwork Size	No. Yes, if Back Artwork is provided.	Number Size of the width 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
Back Artwork Vertical Offset	No. Yes, if Back Artwork is provided.	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. Yes, if Back Artwork is provided and the product is a Poster, Mug, or Case.	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.

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-ultra-cotton-tank
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 Ultra Cotton Tank T-shirt with the Donut Madness artwork in the left-hand side of the product, with 2.4 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.

As it is a square, 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

It behaves pretty much like posters, with a slight difference: 100% percent of width refers to both sides of the mug. So then, if 50% is specified as Artwork Width, it will take the whole area of one side of the mug:

So then, to take the half of one side, we have to set 25% as width, which is one-quarter of the whole printable area: