WEBVTT

1
00:00:01.206 --> 00:00:05.578
In this episode we bring a whole list of products into the catalogue at once, from a

2
00:00:05.578 --> 00:00:06.202
spreadsheet.

3
00:00:08.255 --> 00:00:13.075
If you already have your products in a spreadsheet, you do not have to type them in

4
00:00:13.075 --> 00:00:15.688
one by one. Open Import in the Catalog group.

5
00:00:16.791 --> 00:00:22.384
The page has two tabs. Import CSV brings products in, and Export CSV takes your

6
00:00:22.384 --> 00:00:28.331
whole catalogue out as a file, which is handy for editing prices in bulk. A CSV file

7
00:00:28.331 --> 00:00:31.941
is just a spreadsheet saved in the simplest format.

8
00:00:32.421 --> 00:00:36.863
The first row of the file must be a header, naming each column. The Download

9
00:00:36.863 --> 00:00:41.480
template button gives you a file with every column the system understands. Load

10
00:00:41.480 --> 00:00:45.630
example fills the box with a small sample, so you can see how it looks.

11
00:00:46.941 --> 00:00:52.438
You can choose a file, or just paste into the box. We will paste a short list of

12
00:00:52.438 --> 00:00:58.003
camping drinkware. The columns are name, SKU, price, cost, category, quantity and

13
00:00:58.003 --> 00:01:02.126
outlet, which is the store code that gets the opening stock.

14
00:01:02.276 --> 00:01:07.310
As soon as there is data, a preview appears underneath. Nothing has been saved yet.

15
00:01:07.310 --> 00:01:09.494
The preview is your chance to check.

16
00:01:11.032 --> 00:01:15.906
Look at the orange warning. It says row three has a price of A B C, which is not a

17
00:01:15.906 --> 00:01:20.839
number. That row is highlighted in red in the table. The preview just caught a typo

18
00:01:20.839 --> 00:01:23.038
that would have been a problem later.

19
00:01:23.700 --> 00:01:27.726
We fix the text in the box. The Camp Towel should cost nine dollars.

20
00:01:33.047 --> 00:01:38.077
The warning is gone, and all three rows look right. The category column can be a

21
00:01:38.077 --> 00:01:43.233
path, with missing categories created for you, so Drinkware is made if it does not

22
00:01:43.233 --> 00:01:48.389
exist. An SKU that already exists updates that variant's price and cost instead of

23
00:01:48.389 --> 00:01:49.584
making a duplicate.

24
00:01:49.734 --> 00:01:53.332
Now press the Import button. It says how many rows it will bring in.

25
00:01:55.230 --> 00:02:01.050
One last question. It asks you to confirm, and reminds you that a row whose SKU

26
00:02:01.050 --> 00:02:07.239
already exists updates that product, while other rows create new ones. Press Import.

27
00:02:07.541 --> 00:02:09.821
The products are created. Now let's check.

28
00:02:11.738 --> 00:02:16.839
To check, open Products and search for camp. All of them are there, with the prices

29
00:02:16.839 --> 00:02:17.700
from the file.

30
00:02:18.863 --> 00:02:23.402
The stock quantities came in too. Switch the store at the top right to Main Street,

31
00:02:23.402 --> 00:02:26.901
and the stock column shows the opening quantities from the file.

32
00:02:28.173 --> 00:02:33.045
That is how you load a catalogue in minutes. In the next episode, we print shelf and

33
00:02:33.045 --> 00:02:34.611
price labels with barcodes.