CSV Integration Guide
Please sign-in on website, open Profile page and select Integrations / CSV...:
https://superfriday.co.uk/csv-orders
...select a CSV file and upload it.
A CSV template file is present on your website:
https://superfriday.co.uk/images/pictures/banner/integrations/csv_orders.csv
CSV can contain few orders, each one should start with order details (shipping, address, notes) and then one or more rows about each product ordered (first column should be empty to specify that it’s product order item but not a next order, design position and design URL can be repeated few times to specify images for each print/decoration side):
|
Shipping Type Regular/Express |
Brand Name |
First Name |
Last Name |
Company |
Address Line 1 |
Address Line 2 |
City |
County |
Country |
Postcode |
Notes |
|
Part Number |
Quantity |
Description |
Printed Label Name |
Sewn Label Name |
Design Position |
Design URL |
Design Position |
Design URL |
Design Position |
Design URL |
|
|
Part Number |
Quantity |
Description |
Printed Label Name |
Sewn Label Name |
Design Position |
Design URL |
Design Position |
Design URL |
Design Position |
Design URL |
|
|
… |
Shipping Type Regular/Express – a compulsory field to specify shipping method (Regular or Express).
Brand Name – optional, to specify a Brand (which can be setup by the user at /profile page)
First Name, Last Name – compulsory, a customer name to be shown on the shipping address details of the order
Company – optional, customer’s company name
Address Line 1, Address Line, City, County, Country, Postcode – compulsory, shipping address details of the customer
Notes – optional, order comments
Part Number – compulsory, a code (SKU) of the product, the system will use it to find a correct product or product variation (aka “option value”) on the Super/Friday website, so all website products and product variation codes should be unique.
Quantity – compulsory, qty of products ordered
Description – compulsory, product name to be shown to the customer on the printed order receipt, etc.
Printed Label Name – optional, print label to be used (it needs to be setup by user at /profile page and linked to the brand of the product purchased)
Sewn Label Name – optional, sewn label to be used (it needs to be setup by user at /profile page and linked to the brand of the product purchased)
Design Position – compulsory, where to put the design, on which product side (front back, etc.), will be used if corresponding decoration side setup for the product; or can be set to ‘mockup’ to highlight that it’s a product mockup image. Design positions are shown on product page and the same values need to be specified as “Design Position” value.
Design URL – compulsory, an URL of the design/mockup image file to use
So, "Design Position” and “Design URL” pairs can repeat as many times as needed; as also it can be not design, but a mockup —‚ in this case it needs to be specified as pair of values “mockup” and "Mockup url” (URL of the mockup image)
Here is an example of CSV file:
https://superfriday.co.uk/images/pictures/integrations/csv_orders_example.csv
And here is another example:
|
Express |
BrickwebUA |
Rita |
Shkolyarenko |
Brickweb |
The Strawberry Fields Digital Hub |
Euxton Lane |
Chorley |
Lancashire |
United Kingdom |
PR7 1PS |
test order |
|
LB |
10 |
Lunch bag |
Eva |
Front |
https://images.app.goo.gl/XnW5vguQp62GZDZ97 |
Back |
https://images.app.goo.gl/cFcms7wbiakUW9r1A |
As soon as a CSV is uploaded — new order(s) will be created:
User will be able to review the order on the Order Tracking page:
https://superfriday.co.uk/order-tracking
Also the website admin will see it on Orders Manager too...
https://superfriday.co.uk/cc/v2/shop/orders
...with all customer and shipping address details specified on CSV file:
Our example CSV used the “BrickwebUA” brand and labels specified at /profile page:
Ability to specify Sewn Label can be set at Control Centre / Users Manager per user (as to use it as sewn label the image of the label needs to be reviewed and altered by website admin, while Print Label available for all users):
https://superfriday.co.uk/cc/v2/users/
As also, at Products Manager you can specify what label types available for each product:
https://superfriday.co.uk/cc/v2/shop/products
