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.
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.
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.
5
Select the Brand (e.g., Johnnie-O) from the dropdown.
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.
8
Select the broad Product Category (e.g., Tops).
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.
11
Enter the Weight (lb) to ensure accurate shipping calculations at checkout.
12
Enter the Wholesale Cost and Retail Price.
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.
You can turn on or off the sizes that you want to include in the scale by clicking on them. You can also create a custom size scale if the default scales don't apply.
Always include the full size scale that the vendor makes for that product (can be verified by their web listing or the wholesale catalog).
Even though we may not have ordered certain sizes, by including all "available" sizes the vendor offers will allow us to easily ring up those sizes for special order.
Additionally, try not to include sizes that the vendor doesn't make (for example some brands don't make a 31, or only offer it in certain styles). This is less important, it will just display out of stock since there won't be inventory in that size anyway, but good practice to avoid a special order for a size that doesn't exist.
15
Copy the UPC from your wholesale portal and paste it into the Barcode or SKU field for the corresponding size variant.
Sometimes may not have barcode info when inputting. In these cases you can leave it blank and we will assign the barcodes when the products arrive, or create our own barcodes for certain products that don't come pre-labeled.
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.
17
Paste the text into the Product Content field.
Use Ctrl+Shift+V (or Paste and Match Style) to paste without formatting. Standard pasting can bring over hidden HTML styles or internal vendor links that push customers away from our site.
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.
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.
Keep tags simple! Always include at lease the brand, season, & color.
Brand: Match spelling & format as it is in the input form. At somepoint I will have the form automatically fill the vendor tag based on what you select in the drop down at the beginning.
Season: Season abbreviaion (FW for Fall/Winter, SS for Spring/Summer) + Year e.g., "FW25" for Fall/Winter 2026 or "SS26" for Spring/Summer 2026
Color: the general color as it appears to you (not the vendor color name) e.g. "green" not "deep forest"
A few relevant descriptors are useful as well, but don't overthink it. The activity it may be used for, the material, a detail about the garment type (such as crewneck or v-neck)
Example tag string: [Johnnie-O, SS26, navy, golf, performance, quarter zip]
Why tags are important: a lot of our online store is organized based on how products are tagged. The brand tag makes sure it gets sorted into our brand collections & the season tag makes it appear in new arrivals and also allows us to set end-of-season pricing on products in bulk. If these are wrong (left blank, typo, or just incorrect) the product will not display or be sorted properly.
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.
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.
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.
Items in the Product Queue can be edited and re-saved.
27
Click Download CSVs to generate a Shopify-ready import file.
28
Navigate to the Products dashboard in Shopify and click Import.
29
Click Add file and select the Shopify CSV file you just downloaded.
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.
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.