Getting your product information ready for importing to your website

Posted in Magento on 14 October 2016

This post has been archived

The content of this post has not been updated since 2015, and may be out of date. Extra care should be taken with any code provided.

Product imports are an inevitable part of any ecommerce project.

At some point the information you have on your products wherever it may be stored – EPOS systems, paper catalogues, back of your head – needs to be upload to your website.

This is often a difficult part of the project to explain, but your data is EVERYTHING. Without good data with clear product information your website is not going to do anything. All your products will at least need:

  • Product code (SKU) or at least the manufacturers code.
  • Title a unique title for each product
  • Some form of description preferably two (a short one sentence intro, and a fuller detailed description of the product)
  • price what you’ll expect customers to pay (usually excluding VAT)
  • category how you want your products grouped together on your website

Before even thinking about getting an ecommerce website set up you should be considering how to get all that information together in one place preferably a spreadsheet of sorts.

I’m going to be expanding this post out as there are way too many attributes.

Related Magento Posts

October 2023

Magento database structure

The database structure of Magento is designed to store and manage various aspects of an e-commerce website, including products, orders, customers, and more. Understanding the...

Continue reading

August 2023

Accessibility in ecommerce websites

In the digital age, where online shopping has become an integral part of our lives, ecommerce websites hold the key to business success. Amidst the...

Continue reading

August 2023

Using Magento to get small businesses online

For small businesses aiming to establish a formidable online presence and drive sales, Magento emerges as a powerful e-commerce platform offering a suite of features...

Continue reading

July 2023

How can I speed-up my Magento website?

Speed optimisation is crucial for a Magento website as it directly impacts user experience, conversions, and search engine rankings. You should prepare your server so...

Continue reading

June 2023

.htaccess: Enable GZIP Compression for Magento

Enable Gzip compression on your server to compress your website's files before sending them to the visitor's browser. This significantly reduces the file size, resulting...

Continue reading

April 2023

Popular Payment Gateways

Ecommerce payment gateways are critical components of any online store, as they enable merchants to accept payments from customers securely and conveniently. There are many...

Continue reading

More Magento Posts