CSV Ordering

If you're running your store outside the Shopify or Etsy platform, You can upload a CSV (Comma Separated Values) file to your ShineOn account, and we'll import the orders and ship them directly to customers.

CSV ordering is the perfect way to give us batches of orders to fulfill without the need for automation.

You can register an account with us and submit orders to us via a CSV file via the "Special Orders" sales channel.

CSV Ordering works like this:

You create products using our system, which will then give you an SKU to use.
You add your billing information so we can charge you the base cost of the orders.
You submit lists of orders to us via a CSV file; which includes important information such as SKU, details of the customer, and customization options.
We ship the orders directly to the customer and provide tracking information on the orders page.

To get started, you will need:

Some time to familiarize and test the process before accepting live orders.
To register an account with us and add billing information.
If you're expecting a lot of orders daily, someone to help you process and upload orders, and download the tracking information for shipped orders.

Sections to this guide:

Register
Set up billing information
Creating a product and getting an SKU
Preparing CSV files
Importing CSV files
Exporting Tracking information
Creating product renders

Register an account

Log in to your ShineOn dashboard, or if you're new, create an account via app.shineon.com
From your dashboard, click the dropdown at the top and go to connect new store.

Click the link to open up a partner API / CSV account.

Setup billing information

You can link your credit card to your partner account so we can bill you for new orders. Without this, your imported orders won't be produced, and you'll be limited on how many orders you can import.

Click the Settings cog at the top, and go to Account Settings
Scroll down to add payment information.

Once you've added a payment method, make sure auto-billing is enabled, so your orders will get paid and produced automatically.

We'll email you invoices when we bill you for new orders, and you can turn this option off here, too.

If you've created test orders, these should be cancelled by our support team before you add your billing information, or you will be charged for them.

Creating a product and getting an SKU

The SKU is one of the most important pieces of information you will need for CSV orders, as it tells us what items we need to ship to the customer. To get an SKU, you need to create the product.

Go to Add Product.

Select the I will include designs on my SKUs radio button to update the catalog.

Choose your product and create it.

The, I will include designs with each order option in the product catalog will give you access to more products from our catalog, but the CSV file you send over will need to include additional line items for the artwork which is to be applied to each individual order. This isn't recommended if this is your first time using CSV ordering.

Locate the SKU

The SKU is located inside the product editor.

Go to Products On the left
Locate the product within the list and click the name to enter the product editor.
The product SKU can be found at the bottom. Each variant has it's own SKU.

Preparing CSV files

Your CSV file must follow a specific format, and examples can be found within the product editor for any products you have made under the special orders sales channel

The fields used for basic CSV orders are:

source_id: Your own reference for the order.Unique, unless grouping line items together into a single order.
line_item_id: Your own reference for the line item.
line_item_sku: The ShineOn SKU of your product
line_item_quantity: Quantity of the line item
line_item_engraving_line1: Line 1 of the engraving for the item.Only required for engraved variants.
line_item_engraving_line2: Line 2 of the engraving for the item.Only required for engraved variants.
email: Email address for the customer.Only used to help locate orders later.
shipping_name: Full name the item is being shipped to. Max 50 characters.
shipping_address1: Line 1 of the shipping address.Max 50 characters.
shipping_city: Shipping address city.Required.
shipping_state: Shipping address state.Required for US addresses.
shipping_zip: ZIP or postal code.Required. 5 digits minimum. For Intl addresses without a ZIP, enter 00000
shipping_country_code: ISO-2 country code.Required. 2 characters only. See Here For The Correct Code
line_item_print_URL: Insert the URL of your artwork here. You can use this site to give your artwork file a URL to use.

If a customer has ordered multiple items, you can group them together by using the same source_id for each line item. This only works if all the line items are in the same import. Otherwise, the source_id should be unique and cannot be reused on future imports.

Importing your CSV

On the left menu click Orders > Imports and then New Import

Pick your CSV file then click New Import

Once uploaded, your import will be assigned an IMPORT ID, and appear on the list. Once it's complete, you'll see the outcome of how many orders were imported. Click the number to view the list of orders and their details.

If there are errors, the line will be skipped. You can retry the order in a fresh import.

Exporting tracking.

You can export the tracking numbers for your orders using the Create Report menu on the right side of the orders screen.

As we ship items out, this export will be populated with the tracking numbers. If there are gaps, the order hasn't shipped out yet. Re-download it periodically to grab newer tracking information.

Creating product renders.

We provide access to our powerful renders engine, which allows you to create mockups for your listings.

To generate a mockup with your design:

Go to the product you would like to make a mock-up for.

Scroll down and find the Preview Renders button.
Click it, and upload the artwork you would like to apply.

To save an image, Right click > Save image as.

CSV Ordering

Creating product renders.

Related articles