(If you are looking help with CSVs in a general sense your issue may be resolved here: [Common CSV Issues] 


Example CSV: [Stock CSV Example]

Datatype Reference Sheet: [Stock CSV Data Refrence]


There are several ways to do stock consignments with some crossover between them.


Terminology:

An ITEM Box - is the box that a SINGLE item is packed in.

A STOCK Box - is the box of many ITEM boxes are packed into, this is what will be on the shelf.

A SHIPPING Box - is the box one to many STOCK boxes are sent to the distribution centre in.



Single ITEM Consignment:

To start go to the "Upload Single" tab under "Stock Consignments". 

This is for sending either one BOX or one PALLET of only ONE type of item.


Item:

This is the item you will be sending. This is a drop down list of products you have uploaded to the system. If you need help with this see [Adding Items].

SKU:

An SKU is only needed when multiple products share the same EAN, such a different colour variations of the same product. If this is not needed however, it can just be left blank.


Pallet (checkbox):

This delineates weather you are sending a single box of stock boxes or a pallet of boxes of items.

The process then differs weather the "Pallet" box is checked.


Single ITEM Box Consignment:

For this the "Pallet" checkbox must be left unchecked. 

Shipping Box Height/width/depth (cm):

These are the dimensions of the SHIPPING box as a whole NOT the ITEM or STOCK boxes (Note: there is an exception if you are only sending a single STOCK box then this will count also as a SHIPPING box). These are all in CM.

Please Note: the box should be able to fit on our shelves for a list of our shelve sizes see [Shelf space sizes placeholder link].

Shipping box weight (kg):

The total weight of the SHIPPING box your are sending us when fully packed with the items in it.

Print Own Labels/Print labels at Fulfilment Centre:

These options are mutual exclusive i.e. only one can be selected.

If you wish to label the boxes and items yourself select: "Print Own Labels" if you would like us to label them once it has reached the distribution centre select: "Print Labels at Fulfilment Centre".

Stock Quantity:

This field will be filled in automatically as the multiplication of Box Quantity and Items Per Box check this to make sure it lines up with how many items you are sending.

Box Quantity:

How many STOCK boxes will be in your SHIPPING box.

Note: if you are only sending a single STOCK box then this will count also as a SHIPPING box and need to be labelled as both if you chose to print your labels at home.

Items Per Box:

How many ITEMS will be in one STOCK box.

Stock Box Height/Width/Depth:

The dimensions of a single STOCK box. All in CM.

Stock Box Weight:

The weight of a single STOCK box in KG. If you are sending multiple STOCK boxes within one SHIPPING box the SHIPPING box weight should be roughly equal to the STOCK box weight multiplied by the number of STOCK boxes.

If you are only sending one STOCK box as a SHIPPING box these should instead be equal.

Shipping Reference:

This is an arbitrary field for your own personal referencing, it can be whatever you like.

Batch Number:

This is used for grouping items that were made together, then if a product needs to be recalled you can limit this to only a specific batch rather than every instance of that ITEM.

Expiry Date:

Normally we endeavour to use a First In First Out (FIFO) system to determine which ITEM we send out to fulfil orders. If the ITEM has only a limited shelf life we will instead send out items that are going to expire quickest first. If the item has no expiry date leave this field blank.


Finishing Off:

Once you have uploaded your consignment it will appear on the "Consignments" tab.

If you think something is wrong with the consignment you just you will have 15 minutes to cancel the consignment before it is processed.

If you selected to attach the labels yourself these can be found under the drop-down menu "Downloaded Labels". 

There will be one label named "Inbound Stock Consignment" that if for the SHIPPING box, and number of "Stock Box" labels to go on each of the STOCK boxes on the Pallet. Note: if you are only sending a single STOCK box then this will count also as a SHIPPING box and need to be labelled as both.

Once this is done press the "Labels Affixed" button to confirm.


Single ITEM Pallet Consignment:

When sending a Pallet of a Single ITEM the size of the pallet is standardised so SHIPPING size is unneeded like it was in the previous section.

Stock Quantity:

This field will be filled in automatically as the multiplication of Box Quantity and Items Per Box check this to make sure it lines up with how many items you are sending.

Box Quantity:

How many STOCK boxes will be on your Pallet.

Items Per Box:

How many ITEMS will be in one STOCK box.

Stock Box Height/Width/Depth:

The dimensions of a single STOCK box. All in CM.

Stock Box Weight:

The weight of a single STOCK box in KG. 

Shipping Reference:

This is an arbitrary field for your own personal referencing, it can be whatever you like.

Batch Number:

This is used for grouping items that were made together, then if a product needs to be recalled you can limit this to only a specific batch rather than every instance of that ITEM.

Expiry Date:

Normally we endeavour to use a First In First Out (FIFO) system to determine which ITEM we send out to fulfil orders. If the ITEM has only a limited shelf life we will instead send out items that are going to expire quickest first. If the item has no expiry date leave this field blank.


Finishing Off:

Once you have uploaded your consignment it will appear on the "Consignments" tab.

If you think something is wrong with the consignment you just you will have 15 minutes to cancel the consignment before it is processed.

If you selected to attach the labels yourself these can be found under the drop-down menu "Downloaded Labels". 

There will be one label named "Inbound Stock Consignment" that if for the Pallet, and number of "Stock Box" labels to go on each of the STOCK boxes on the Pallet.

Once this is done press the "Labels Affixed" button to confirm.


Mixed ITEM Consignment:

If you wish to send multiple different items on the same Pallet this need to be done via CSV file upload. 

This is done on the "Upload CSV" tab of "Stock Consignments". The CSV template as well technical descriptions of all the datatypes can be found here, as well as linked at the top of this page.

To save headaches down the line we highly recommend that if you are using Microsoft Excel for you CSV files, that you format all columns to be "text" for the Why and How please see [BEWARE EXCEL and other CSV Issues]. The fields most likely to be affected by this are EAN and Expiry Date.



Name:

Name of ITEM this needs to be a case sensitive match to an ITEM in your Products page.

Description: 

A short description of the ITEM.

Brand:

ITEM's Brand name, if the ITEM has no preexisting brand then this will be your brand.

Prohibited Type 1/2/3:

Currently Unused please ignore.

EAN:

The unique identifier for your ITEM. If ITEM did not have a barcode use a SUID instead in the field below:

Selazar Unique ID (SUID):

An alternate Unique identifier if the ITEM did not have it's own.

JAN:

Currently Unused please ignore.

UPC:

Currently Unused please ignore.

ISBN:

Unique identify for use only when shipping books.

MPN:

Currently Unused please ignore.

SKU:

An SKU is only needed when multiple products share the same EAN, such a different colour variations of the same product. If this is not needed however, it can just be left blank.

Stock Count:

This is the total number of items being shipped and should be equal to the number of STOCK boxes multiplied by the number of ITEMS per STOCK box.

Box Quantity:

Number of STOCK boxes in consignment.

Items Per Box:

Number of Items per STOCK box.

Box Height/Width/Depth:

Dimensions of a single STOCK box.

Box Weight:

Weight of a single STOCK box.

Region:

This must be a correct two character country code. For a list of these check: [Country Codes].

Expiry Date:

If the ITEM has a limited shelf life this is when the product can no long be picker to fulfil orders.

Batch Number:

This is used for grouping items that were made together, then if a product needs to be recalled you can limit this to only a specific batch rather than every instance of that ITEM.



Finishing Off:

Once you have uploaded your consignment it will appear on the "Consignments" tab.

If you think something is wrong with the consignment you just you will have 15 minutes to cancel the consignment before it is processed.

If you selected to attach the labels yourself these can be found under the drop-down menu "Downloaded Labels". 

There will be one label named "Inbound Stock Consignment" that if for the Pallet, and number of "Stock Box" labels to go on each of the STOCK boxes on the Pallet.

Once this is done press the "Labels Affixed" button to confirm.