Home eCommerce Success Blog 2. How To Add Your Products Manually In Your Shopify Store #12
June 27, 2022

2. How To Add Your Products Manually In Your Shopify Store #12

By Veronica Jeans, Shopify Queen & Bestselling Author
2. How To Add Your Products Manually In Your Shopify Store #12 | Veronica Jeans

Let’s get ready to implement your products in Shopify.

Integrating your Products in Your Shopify Store

There are two ways to get your products into your online store. You can either add them one by one manually or you upload your products in bulk with a spreadsheet template.

Add/Upload Your Products Manually

**Where to find this in Shopify? Products > All Products

If you only have a few products, it is easy to create a product page for each of your products manually.

Where to add your products in your Shopify store- Veronica Jeans Shopify Queen & Bestselling Author ' Shopify Made Easy'

Upload Your Products In Bulk

If you have a large number of products and content to add to your Shopify store, you can upload your products in bulk which is a quick way to upload your products.

How To Add Your Products in Your Shopify Store

It is easier to add content to your product page if you prepare your information before you start adding or uploading your product details.

Here are the main sections of the information you will need for each product you are adding to your Shopify store. Each section has different choices depending on what you are selling and how you are shipping your products to your customer.

  1. Title
  2. Description
  3. Photos, Images & Videos
  4. Prices & Cost per item
  5. Inventory, Quantity, Locations, SKU & Barcode (ISBN, UPC, GTIN, etc.)
  6. Shipping, Weight (for physical products) & Custom Information
  7. Options & Variants
  8. Search Engine Preview Listing
  9. Product Availability
  10. Product Organization
  11. Product Theme Templates

1. Product Title

Title and description for your products in Shopify- Veronica Jeans Shopify Queen & Bestselling Author ' Shopify Made Easy'

The title of your product page is the name of your product. Try to use a search term somebody will search for in Google, for instance, to look for a similar product. Giving your product a fancy title will not aid potential customers in finding your product on the internet.

How to write a good title for your products.

  • Watch your title length
  • Give every page a unique title
  • Use a primary keyword in your title
  • Put important primary keywords first

Write for your customers

  • Don't overdo SEO (Search Engine Optimization) keywords

Moz says:

“While there is no penalty built into Google's algorithm for long titles, you can run into trouble if you start stuffing your title full of keywords in a way that creates a bad user experience, such as Buy Widgets, Best Widgets, Cheap Widgets, Widgets for Sale”

TOOLS: Headline Analyzer

What is the Headline Analyzer?

“This free tool will analyze your headline to determine the Emotional Marketing Value (EMV) score. As you know, reaching your customers in a deep and emotional way is a key to successful copywriting, and your headline is unquestionably the most important piece of copy you use to reach prospects.

Your headline will be analyzed and scored based on the total number of EMV words it has in relation to the total number of words it contains. This will determine the EMV score of your headline.”

Try it out: Https://headlineanalyzer.com

2. Product Description

your title and product description in Shopify store- Veronica Jeans Shopify Queen & Bestselling Author ' Shopify Made Easy'

The content of your product description should convince the potential customer it will improve their lives in obvious, measurable ways.

Before you begin writing your product descriptions, make an outline of the features and benefits of your product. Think about how the product either increases pleasure or reduces a pain point. It solves a problem right?

For every feature that you list, figure out how this will directly benefit the buyer.

Difference between FEATURES and BENEFITS for your products?

Features:

Simply, a feature is something that your product has or is. The dimensions, specifications, ingredients, material, etc of your product.

Features work on a factual level rather than on an emotional level.

Try to answer - ‘what is the Product’?

Benefits:

Benefits are the outcomes or results that users will (hopefully) experience by using your product or service – the very reason why a prospective customer becomes an actual customer.

It is the end result of what your product accomplishes!

Question for the benefits of your product:

As a result of owning this product you will get/have/obtain/become/feel/be perceived/look/etc.

Remember: Nobody really wants to buy what you sell. The reality is, the only thing your buyer wants to know, is WIIFM (what’s in it for me).

TIP 1: Do some research and really use your audience (can be friends and family if you don’t have an audience yet) to see if they really understand what you are selling and why they should buy your products.

TIP 2: Check to see what other brands are doing.

When you are writing the benefits and features of your product, change the way you think about how you describe your product.

TIP: Sell a lifestyle, not just a product! This is a very sophisticated form of marketing.

Shopify Blogs have amazing tips on how to write descriptions that sell successfully. But here are some quick tips.

7 Easy Rules to Write Great Product Descriptions

  1. Know Who Your Target Audience is
  2. Focus on the Product Benefits
  3. Tell Mini Stories
  4. Use Natural Language and Tone
  5. Use Power Words That Sell
  6. Make it Easy to Scan
  7. Optimize for Search Engines

Now that you have your description of the benefits and features of your product worked out and added to your product page, we need to make sure our description makes an immediate impact on a potential buyer.

Part of your description should be above the ‘Buy Button’, but not so much it pushes the ‘Add to Cart’ button too far down your page when viewed in a browser.

This part will be the benefits of your products.

The rest of the description is below the ‘Buy Button’ or ‘Add to Cart’ button.

The choice to split your product descriptions will only be available with some paid templates.

The free Shopify templates do not have the choice to have both a short description and a long description.

Here is a FORMULA for your descriptions of your product.

Ezra Firestone says:

2 Headlines:

1st Paragraph: Ownership benefit-focused (ALL CAPS)

2nd Paragraph: 1 - 2 sentences of the product benefits

Should you use the same descriptions/content as your manufacturer/vendor?

This latest advice from Google is useful in that it clarifies Google’s position, which I quickly paraphrase below:

“There is no duplicate content penalty

Google rewards UNIQUENESS and the signals associated with ADDED VALUE

A good rule of thumb is; do NOT expect to rank high in Google with content found on other, more trusted sites, and don’t expect to rank at all if all you are using is automatically generated pages with no ‘value add’.

While there are exceptions to the rule, (and Google certainly treats your OWN duplicate content on your OWN site differently), your best bet in ranking in 2019/2020 is to have one single (canonical) version of content on your site with rich, unique text content that is written specifically for that page.

Google wants to reward RICH, UNIQUE, RELEVANT, INFORMATIVE, and REMARKABLE content in its organic listings – and it has raised the quality bar over the last few years.”

TIP: If you want to rank high in Google for valuable key phrases and for a long time – you better have good, original content for a start.

What is next?

3. How Add Product Photos, Images & Video To Your Shopify Store

RELATED ARTICLES FOR YOUR PRODUCT PAGE IN SHOPIFY:

1. How To Create Successful Products Pages In Your Shopify Store

4. Tips How To PRICE Your Product sFOR Your Shopify Store

5. How Add Your Product Information For Your Shopify Store

6. Shipping Information For Your Products In Your Shopify Store

7. How To Add Product Options & Variants In Your Shopify Store

8. How To Optimize Your Product Page For Google In Shopify

9. How To Sell More Products With Sales Channels In Your Shopify Store

10. Strategically Organize Your Products For More Sales In Your Shopify Store

11. Optimize Your Product Pages For Great Conversions In Your Shopify Store

12. How To Upload Your Products In Bulk To Shopify

13. How To Create 2 Types Of Gift Cards In Your Shopify Store

MORE INFORMATION ABOUT CONTENT FOR EACH ARTICLE ABOUT PRODUCT PAGE IN SHOPIFY: Check it out here.

'Shopify Made Easy' How To Launch Your Shopify Store Shopify 101 - Steps & Tips

Leave a comment

Comments will be approved before showing up.

Also in eCommerce Success Blog

What is the difference between Shopify CSV and Matrixify Products import and export?

By Veronica Jeans, Bestselling Author November 16, 2024

Shopify CSV vs Matrixify Excel: A Comprehensive Guide to Product Management

Managing product data in an e-commerce platform can be a complex task, especially when dealing with large inventories. This article compares two prominent methods for handling product data in Shopify: the native CSV system and the Matrixify Excel approach. We'll explore how these tools differ and why choosing the right one can significantly impact your workflow efficiency.

Shopify vs Matrixify Comparison

FEATURE SHOPIFY MATRIXIFY
File Type CSV files Excel files
Import/Export Visibility No visibility or control; must wait for email. Full visibility, progress updates, and cancel options.
Export Options Exports full store with all fields, leading to duplicate rows. Granular export filtering, saves time and file size, no duplicate rows.
Multiple Images Requires copying rows and adding each image to a separate row. Allows multiple images in one row, separated by semicolons.
Metafields Cannot export/import Metafields. Exports and imports Metafields as columns in the table.
Product Updates Replaces entire product; no field-specific updates. Allows individual field updates without replacing products.
Template Suffix Cannot update in bulk. Supports bulk Template Suffix updates as a column.
Product IDs Deletes and recreates products with new IDs, losing references. Keeps IDs and references intact, preserving Custom Collections.
File Size Limit 15 MB (~10,000 products). Supports large files (e.g., 600,000+ products).

 

Detailed Comparison between Shopify & Matrixify Product Management & Uploads

File Format and Basic Handling

Shopify CSV

  • File Format: Limited to CSV files only
  • Process Visibility: Upload and wait system
  • User Control: Minimal interaction during process
  • Progress Tracking: None email notification upon completion
  • File Size Limitation: Strict 15MB limit (approximately 10,000 products)

Matrixify Excel

  • File Format: Works with Excel files (.xlsx)
  • Process Visibility: Real-time progress tracking
  • User Control: Full control with cancel option
  • Progress Tracking: Live progress bar with time estimates
  • File Size Limitation: Handles large files (600,000+ products)

Data Management Capabilities

1. Product Export Features

Shopify CSV

  • Exports entire store inventory
  • No filtering options
  • All fields included regardless of need
  • Creates duplicate rows for variants and images
  • Limited customization options

Matrixify Excel

  • Granular export control
  • Custom field selection
  • Filtered exports based on specific criteria
  • Efficient row management
  • Optimized file size through selective exporting

2. Image Handling

Shopify CSV

  • One image per row requirement
  • Multiple images need row duplication
  • Complicated management for product variants
  • Image Alt Text updates require full product reimport

Matrixify Excel

  • Multiple images in single row
  • Semicolon-separated image sources
  • Streamlined variant management
  • Independent Image Alt Text updates

Advanced Features

3. Metafields Management

Shopify CSV

  • No metafield support
  • Cannot export existing metafields
  • No import capabilities for metafields
  • Requires separate solution for metafield management

Matrixify Excel

  • Full metafield support
  • Export metafields as table columns
  • Direct editing and updating
  • Integrated metafield management

4. Product Updates and Maintenance

Shopify CSV

  • Creates new product IDs on import
  • Breaks existing collection references
  • Full product replacement required
  • No partial updates supported

Matrixify Excel

  • Maintains original product IDs
  • Preserves all existing references
  • Supports partial field updates
  • Selective field modification

5. Inventory Management

Shopify CSV

  • Basic inventory tracking
  • Single location focus
  • No adjustment features
  • Limited variant handling

Matrixify Excel

  • Multi-location inventory support
  • Inventory adjustment tracking
  • Delta-based inventory management
  • Advanced variant generation

6. Template Management

Shopify CSV

  • No template suffix support
  • Cannot modify templates in bulk
  • Limited template customization

Matrixify Excel

  • Full template suffix support
  • Bulk template modifications
  • Simple column-based management

Special Features

Matrixify Exclusive Capabilities

1. HTML Code Optimization

  • Automatic fixing of escaped HTML code
  • Converts symbols to proper HTML

2. Variant Management

  • Bulk variant generation
  • Option combination support
  • Semicolon-separated combinations

3. Publishing Control

  • Flexible channel publishing
  • Online and POS integration
  • Custom publishing scope settings

    Best Practices and Recommendations

    When to Use Shopify CSV

    • Small product catalogs 
    • Basic product updates
    • Simple inventory management
    • Standard product configurations

    When to Use Matrixify Excel

    • Large product catalogs
    • Complex product configurations
    • Multi-location inventory
    • Detailed metafield management
    • Bulk template updates
    • Advanced variant management

    While Shopify's native CSV system provides basic functionality for smaller stores, Matrixify Excel offers a more robust, flexible, and efficient solution for managing product data. The choice between the two largely depends on your store's size, complexity, and specific needs. For larger operations or those requiring detailed control over their product data, Matrixify Excel presents clear advantages in terms of functionality, efficiency, and scalability.

    Remember that investing time in learning the more powerful tool can save significant time and reduce errors in the long run, especially as your store grows and your product management needs become more complex.

    Frequently Asked Questions (FAQ)

    General Questions

    What's the main difference between Shopify CSV and Matrixify Excel?

    The main difference is that Shopify CSV is a basic file format with limited functionality, while Matrixify Excel offers advanced features like real-time tracking, multiple sheets, and partial updates. Matrixify also allows you to work with pure Excel files instead of CSV format.

    Which option is better for my store?

    It depends on your store size and needs:

    Use Shopify CSV if:

    •   You have under 10,000 products
    •   You need basic import/export features
    •   You're doing simple updates

    Use Matrixify if:

    •   You have over 10,000 products
    •   You need advanced features
    •   You want better control over updates
    •   You work with multiple locations
    •   You need to manage metafields

    File Size & Limitations

    What are the file size limitations?

    Shopify CSV: 15MB maximum

    Matrixify: Can handle gigabytes of data (600,000+ products)

    How many products can each handle?

    Shopify CSV: small catalog

    Matrixify: 600,000+ products in one import

    Features & Functionality

    Can I update specific fields without replacing entire products?

    Shopify CSV: No, you must replace the entire product

    Matrixify: Yes, you can update individual fields

    How do multiple images work in each system?

    Shopify CSV: Requires separate rows for each image

    Matrixify: All images can be in one row, separated by semicolons

    Can I manage metafields?

    Shopify CSV: No metafield support

    Matrixify: Full metafield support with column-based management

    Import/Export Process

    How do I track the progress of my import?

    Shopify CSV: No tracking wait for email notification

    Matrixify: Real-time progress bar with estimated completion time

    Can I cancel an import once it's started?

    Shopify CSV: No

    Matrixify: Yes, at any time during the import

    Data Management

    What happens to product IDs during import?

    Shopify CSV: Creates new IDs, breaking collection references

    Matrixify: Maintains existing IDs and references

    How are variants handled?

    Shopify CSV: Each variant requires a separate row

    Matrixify: Can generate variants from combinations using semicolon separation

    Technical Questions

    How does each handle HTML in descriptions?

    Shopify CSV: Leaves escaped HTML code as is

    Matrixify: Automatically fixes escaped HTML code to normal HTML

    Can I manage inventory across multiple locations?

    Shopify CSV: Limited location support

    Matrixify: Full multi-location inventory management

    Best Practices

    What's the recommended way to update product prices?

    Shopify CSV: Must upload full product data

    Matrixify: Can update prices alone using a simple price column

    How should I handle large product catalogs?

    Shopify CSV: Split into multiple files under 15MB

    Matrixify: Can handle in single file with filtering options

    Troubleshooting

    What if my import fails?

    Shopify CSV: Check email for basic error message

    Matrixify: Detailed error reporting with specific row/column information

    How do I fix broken product references?

    Shopify CSV: Manually rebuild collections and references

    Matrixify: No action needed references are maintained

    Integration & Compatibility

    Do these work with all Shopify plans?

    Both work with all Shopify plans, but Matrixify requires a separate subscription.

    Can I use these with other e-commerce platforms?

    Shopify CSV: Shopify-specific format

    Matrixify: Designed for Shopify but Excel format is more universal

    Support & Resources

    Where can I find documentation?

    Shopify CSV: Shopify Help Center

    Matrixify: Comprehensive documentation with tutorials and examples

    Is there technical support available?

    Shopify CSV: General Shopify support

    Matrixify: Dedicated support team with Excel/import expertise

    Cost & Efficiency

    Which option is more time-efficient?

    Matrixify is generally more time-efficient due to:

    Faster processing of large files

    • Ability to make partial updates
    • Better error handling
    • Real-time progress tracking

    How do they compare in terms of cost?

    Shopify CSV: Free with Shopify subscription

    Matrixify: Requires separate subscription but offers more features and efficiency

    Continue reading

    Lesson 2. Ecommerce Introduction

    By Veronica Jeans, Bestselling Author October 24, 2024

    Lesson 2 for Ecommerce Introduction

    Continue reading

    6 Ways How To Improve Your Ecommerce Store in 2025

    6 Ways How To Improve Your Ecommerce Store in 2025

    By Veronica Jeans, Bestselling Author September 16, 2024

    Innovative strategies that can help you increase customer engagement,

    Continue reading