How to input new products

Learn how to use structured custom forms to build and import standardized product variants, tags, and high-resolution images into Shopify.

By Thomas

This guide outlines how to create standardized product listings using a custom bulk entry form rather than Shopify's default free-form tool. By doing this, you ensure consistent naming conventions, automatically generated SKUs, and clean URL structures for better search engine optimization.

This guide is intended for e-commerce catalog managers and merchandising teams who need to bulk-import new seasonal collections or purchase orders into Shopify.

Access Vendor Purchase Order Data

Before entering data into the form, locate the purchase order (PO) in your wholesale portal (e.g., RepSpark) to access the UPC and style numbers.

1
Click My Orders in your wholesale portal to view recent purchase orders.
Step #1: Click My Orders in your wholesale portal to view recent purchase orders.
2
Click Actions next to the purchase order you want to process.
Step #2: Click Actions next to the purchase order you want to process.
3
Select UPCs to reveal the barcode, style, and color code information for all ordered items.
Step #3: Select UPCs to reveal the barcode, style, and color code information for all ordered items.

Enter Core Product Details

Next, transfer this information to the custom product form alongside details mapped directly from the vendor's consumer-facing website.

4
Click Add product to open the custom bulk entry form.
Step #4: Click Add product to open the custom bulk entry form.
5
Select the Brand (e.g., Johnnie-O) from the dropdown.
Step #5: Select the Brand (e.g., Johnnie-O) from the dropdown.
6
Enter the Style Number matching the purchase order.
Step #6: Enter the Style Number matching the purchase order.
7
Paste the Product Title exactly as it appears on the vendor's website to optimize your SEO rankings.
Step #7: Paste the Product Title exactly as it appears on the vendor's website to optimize your SEO rankings.
8
Select the broad Product Category (e.g., Tops).
Step #8: Select the broad Product Category (e.g., Tops).
9
Select the specific Product Type (e.g., Sweatshirts & Pullovers).
Step #9: Select the specific Product Type (e.g., Sweatshirts & Pullovers).

Configure Variants and Pricing

10
Enter the Color Code and the color's display name.
Step #10: Enter the Color Code and the color's display name.
11
Enter the Weight (lb) to ensure accurate shipping calculations at checkout.
Step #11: Enter the Weight (lb) to ensure accurate shipping calculations at checkout.
12
Enter the Wholesale Cost and Retail Price.
Step #12: Enter the Wholesale Cost and Retail Price.
13
Click Select size scale to define the sizing type for your variants.
Step #13: Click Select size scale to define the sizing type for your variants.
14
Select the appropriate scale (e.g., Alpha for S, M, L) from the dropdown to automatically generate your size rows.
Step #14: Select the appropriate scale (e.g., Alpha for S, M, L) from the dropdown to automatically generate your size rows.
15
Copy the UPC from your wholesale portal and paste it into the Barcode or SKU field for the corresponding size variant.
Step #15: Copy the UPC from your wholesale portal and paste it into the Barcode or SKU field for the corresponding size variant.

Add Product Content and Tags

To ensure consistency, pull descriptions directly from the brand.

16
Copy the product description block from the vendor's retail website.
Step #16: Copy the product description block from the vendor's retail website.
17
Paste the text into the Product Content field.
Step #17: Paste the text into the Product Content field.
18
Match the standard layout sections the vendor displays like Detailing, Fabric, and Care Guide below the main description.
Step #18: Match the standard layout sections the vendor displays like Detailing, Fabric, and Care Guide below the main description.
19
Highlight these headers and use the rich text toolbar to apply an H3 Header format.
Step #19: Highlight these headers and use the rich text toolbar to apply an H3 Header format.
20
Click the Bulleted List icon to structure the specific feature callouts neatly under your new headings.
Step #20: Click the Bulleted List icon to structure the specific feature callouts neatly under your new headings.
21
Click the Product Tags field and enter structural tags.
Step #21: Click the Product Tags field and enter structural tags.

Import High-Resolution Images

Never pull small thumbnail images. Always retrieve the maximum resolution file by clicking and opening the bigger version of the image, then opening the image in a new tab.

22
Clicking an image on a vendor site will usually load it in a larger scale. We want the biggest size image from vendors website possible.

After opening the largest version of the image, right-click and select Open image in new tab.
Step #22: Clicking an image on a vendor site will usually load it in a larger scale. We want the biggest size image from vendors website possible.After opening the largest version of the image, right-click and select Open image in new tab.
23
Copy the direct image URL from the browser's address bar in the newly opened image tab.
Step #23: Copy the direct image URL from the browser's address bar in the newly opened image tab.
24
Paste the URL into the Add Image URL field in the custom form and press Enter.
Step #24: Paste the URL into the Add Image URL field in the custom form and press Enter.
25
Upload images in the same order as they appear on the vendors site. If needed, click and drag the handle next to any uploaded image to reorder the sequence.
Step #25: Upload images in the same order as they appear on the vendors site. If needed, click and drag the handle next to any uploaded image to reorder the sequence.

Export and Import to Shopify

Once the product is fully inputted, we will add it to our Product Queue.

26
Click + Add Product to save the entry to your local bulk queue.
Step #26: Click + Add Product to save the entry to your local bulk queue.
27
Click Download CSVs to generate a Shopify-ready import file.
Step #27: Click Download CSVs to generate a Shopify-ready import file.
28
Navigate to the Products dashboard in Shopify and click Import.
Step #28: Navigate to the Products dashboard in Shopify and click Import.
29
Click Add file and select the Shopify CSV file you just downloaded.
Step #29: Click Add file and select the Shopify CSV file you just downloaded.
30
Click Upload and preview to validate the structured data mapping.
Step #30: Click Upload and preview to validate the structured data mapping.
31
Review the preview screen and click Import products to push the listings live to your catalog.
Step #31: Review the preview screen and click Import products to push the listings live to your catalog.

Q: Why shouldn't I just use the default Shopify product form?

A: Shopify's default form is free-form and open-ended. A custom structured form forces consistent naming conventions, builds uniform SKU strings automatically, and prevents data entry discrepancies that harm SEO and internal search.

Q: What if I don't have barcode data for a specific size?

A: Leave the barcode and quantity fields blank for that variant. You only need to enter data for the specific sizes included in the purchase order, but if you have the full listing of barcodes available, it is good to input them as well so that we have them in our system if we ever get that size in at a later date or special order it for someone.

Q: Why do I need to paste descriptions without formatting?

A: Pasting formatted text carries over hidden styles and internal links native to the vendor's website. Pasting plain text allows the description to adopt your storefront's typography and prevents shoppers from accidentally clicking a link back to the vendor.

Q: How do I make sure I am getting the best quality image?

A: Always right-click the image on the vendor's gallery and select "Open image in new tab." This breaks the image out of the website's thumbnail container and provides a direct URL to the maximum resolution version.

Q: What rules should I follow when tagging a product?

A: Keep tagging simple but highly structured. Always apply the vendor brand, the delivery season (e.g., SS26 or FW25), and a couple of brief descriptors outlining the color and functional type (e.g., 'performance' or 'quarter zip').

Term

Definition

Alpha Sizing

A standard sizing convention using letters (e.g., S, M, L, XL) rather than numeric measurements.

CSV

Comma-Separated Values, a file format used to store and transfer structured spreadsheet data across platforms.

PO

Purchase Order, a commercial document issued to a vendor indicating types, quantities, and agreed prices for products.

SKU

Stock Keeping Unit, a distinct alphanumeric code automatically generated to track a specific product variant internally.

UPC

Universal Product Code, a standardized retail barcode assigned to a specific item for scanning and inventory tracking.

Variant

A specific permutation of a product based on selectable options, such as a unique size or color combination.