Quickstart guide - CSV Ordering

CSV Ordering

If you're running your store outside of the Shopify or Etsy platform, you can register a Partner account with us and submit orders to us via a CSV file.

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.

To get started you will need:

• Some time to familiarize and test the process before accepting live orders.

• To register a Partner 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.

Check out a video walkthrough here:

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 at the bottom to open up a partner 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.

• Go to 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 Products > All Products.

• Go to Create New.

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

• Choose your product and create it.

If you've never made a product before, you can follow this guide.

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 > All products

• 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 an example can be downloaded here. (If this link does not work, log in when requested, and try again)

The fields 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. 

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 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.