| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Artist Name (Firstname Lastname): | Inventory, Restock & Pricing Sheet | |||||
2 | Drop-Off Inventory Date (01/01/2026): | ||||||
3 | Inventory Type (select from dropdown): | Initial Inventory | |||||
4 | Picture Salon Order # (if applicable): | ||||||
5 | DIRECTIONS - This sheet is NOT editable. Go to File → Make a Copy to save your own version. Please name your file: “Inventory, Restock & Pricing Sheet – Firstname Lastname”. Share your sheet: Click Share (top right), enter info@madisonartmarket.com, and select Editor access then send. REQUIRED - Google account needed. This inventory sheet uses Google Sheets. To make a copy and edit it, you must be signed into a Google account. • If you have a Gmail address, you already have a Google account. • If not, you can create a free Google account here. IMPORTANT: Once your sheet is shared with Madison Art Market, continue using the same sheet for all future updates. Do not create new sheets or tabs. Simply add new rows below your previous entries following the directions below. | ||||||
6 | HOW TO FILL OUT & USE THE SHEET: Update your "Inventory, Restock & Pricing Sheet" before each product delivery, restock or pricing change. Please allow 3–5 business days for submissions to be processed and take effect. Note: •Do not delete existing products from the sheet. The only exception is for one-of-a-kind items that will never be restocked. Those rows may be deleted. •This sheet is used to submit inventory updates. Your live inventory and sales can always be viewed in your Artist Consignor Portal. STEP 1: COMPLETE THE TOP SECTION OF THE SHEET Fill in the following fields at the top of the sheet (rows 1-4): • Artist Name • Drop-Off Inventory Date • Inventory Type (select from dropdown) • Picture Salon Order # (if applicable) STEP 2: ENTER PRODUCT DETAILS BELOW Fill in the following columns for each product: • Title • Product Type (must be selected from the dropdown list) • Description • Size • Quantity • Sales Price Add each product on a new row. LISTING PRODUCTS WITH MULTIPLE SIZES, DESIGNS OR COLORS If a product has multiple sizes, list them smallest to largest and group them together. Size Example: Autumn Woods Paper Print– 5×7 Autumn Woods Paper Print – 8×10 Autumn Woods Paper Print – 11×14 Then repeat the same format for Autumn Woods Canvas before moving to the next title. Design Example: Wood Earrings - Flower Wood Earrings - Fruits Wood Earrings - Animals Color Example: Wisconsin T-Shirt - Red Wisconsin T-Shirt - Green Wisconsin T-Shirt - Blue INVENTORY TYPE INSTRUCTIONS: At the top of the sheet, select what you’re bringing in: New items only, Restock only, Restock + New items, Price updates only New Items Only • Add new items by entering each product on a new row • Enter 0 in the Quantity column for all existing items (do not delete them) • Leave all other information unchanged so the items remain available for future restocks • Update the Drop-Off Date at the top of the sheet Restock Only • Update Quantity for items being restocked • Enter 0 in the Quantity for items not being restocked • Do not change or delete other product information • Update the Drop-Off Date at the top of the sheet Restock + New Items • Update Quantity for restocked items • Enter 0 for items not being restocked • Add new products in new rows • Bold the title of new products (Ctrl+B) • Update the Drop-Off Date at the top of the sheet Price Updates Only • Update the Sales Price for items with price changes • Bold the new price (Ctrl+B) • Enter 0 in Quantity for all items • Do not change or delete other product information • Update the Drop-Off Date at the top of the sheet PICTURE SALON ORDER PROCEDURES (only if applicable) • If you have a Picture Salon order going directly into Madison Art Market (Madison Art Market assembles, primarily for vendors who live outside Madison or for a quick restock): list the Picture Salon order number above. • If you're picking up a Picture Salon order first and then dropping it off yourself to Madison Art Market (Vendor assembles: primarily for vendors who want to add branding /sign before products go into inventory) : do not list the order number. Just complete this form as a drop-off. INVENTORY SHEET PRINTING REQUIREMENTS: • Initial inventory: A printed copy of this inventory sheet is required and must be included with your drop-off. • Restocks, New Inventory & Pricing Updates: printing is not required once your sheet has been shared with us on Google Drive. We will reference the shared sheet for future restocks, new inventory additions and any pricing updates. • Missing or incorrect printed forms for initial inventory may delay intake. Tips: • Once you’re familiar with this form, you can collapse this section to focus on entering your inventory. • Searching for a product title to restock, use CTRL+F = Quick Search: find in sheet | ||||||
7 | Title | File Name | Product Type | Description | Size | Quantity | Sales Price |
8 | Enter product title | Enter the file name (if product is produced by Picture Salon) exactly as it appears in your PS online account (e.g., filename.jpg). | Double left click & select from the approved list (Bag, Canvas Print, Card, etc.) Do not enter custom values. | Optional - short description of the product | Use format (8x10, 2oz, 1lb, etc. - do not include symbols or spaces) | Enter whole numbers only | Enter numbers only, no $ sign |
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 | |||||||
24 | |||||||
25 | |||||||
26 | |||||||
27 | |||||||
28 | |||||||
29 | |||||||
30 | |||||||
31 | |||||||
32 | |||||||
33 | |||||||
34 | |||||||
35 | |||||||
36 | |||||||
37 | |||||||
38 | |||||||
39 | |||||||
40 | |||||||
41 | |||||||
42 | |||||||
43 | |||||||
44 | |||||||
45 | |||||||
46 | |||||||
47 | |||||||
48 | |||||||
49 | |||||||
50 | |||||||
51 | |||||||
52 | |||||||
53 | |||||||
54 | |||||||
55 | |||||||
56 | |||||||
57 | |||||||
58 | |||||||
59 | |||||||
60 | |||||||
61 | |||||||
62 | |||||||
63 | |||||||
64 | |||||||
65 | |||||||
66 | |||||||
67 | |||||||
68 | |||||||
69 | |||||||
70 | |||||||
71 | |||||||
72 | |||||||
73 | |||||||
74 | |||||||
75 | |||||||
76 | |||||||
77 | |||||||
78 | |||||||
79 | |||||||
80 | |||||||
81 | |||||||
82 | |||||||
83 | |||||||
84 | |||||||
85 | |||||||
86 | |||||||
87 | |||||||
88 | |||||||
89 | |||||||
90 | |||||||
91 | |||||||
92 | |||||||
93 | |||||||
94 | |||||||
95 | |||||||
96 | |||||||
97 | |||||||
98 | |||||||
99 | |||||||
100 | |||||||