Uploading products into Magento can be a very time consuming task, especially when you need to upload several hundred or even several thousand products. Fortunately there are some shortcuts that you can take to make this a quicker process. This guide will provide a high level overview as to the most effective methods for achieving quicker bulk uploads into Magento. We also suggest you refer to the Magento user guide for detailed tutorials on performing some of these tasks.
Utilize Magento’s Bulk Product Import Feature:
In addition to giving you the ability to add products individually, Magento also provides bulk import capabilities. By utilizing Magento’s bulk import feature a user can import a large number of products from a single CSV file. While the formatting requirements for bulk product uploads into Magento are very specific, you can easily get an understanding as to how your product must be formatted by exporting existing products out of Magento into a CSV file. It’s important to note that since some of your products may be configurable or have multiple variations the CSV formatting requirements for these products will differ from those without.
Upload Images In Bulk:
Instead of individually uploading images at the product level you can upload images in bulk. Bulk image uploads in Magento are always performed via FTP. Additionally, images must be appropriately labeled according to the SKU and or SKU variation of the product they are associated with.
Add Categories and Attributes In Bulk:
While this does not directly correlate to uploading individual products, taking this step will make the entire import process far more efficient. Preparing all of your attributes and categories for a bulk import before uploading any products will allow you to easily associate products with categories and attributes that you will have already created.
Limit File Size For Bulk Imports:
By keeping the number of products you are uploading to Magento at one time to a reasonable number you will prevent any potential server time outs or delays in successfully uploading all of your product data. Dividing a CSV file with 500 + products into two or three files and running separate uploads will require a little more time on the front end but will invariably prevent future headaches.
Updating Existing Products:
You can also utilize Magento’s bulk import feature to update existing products on your storefront. To make bulk updates to existing products via a CSV file you only need to import the SKU field as well as the field(s) which you would like to update. Once successfully uploaded into Magento your changes will take effect on your storefront.
If you’re looking for a faster and easier way to upload and manage both product data and images in Magento, ClaraStream provides a web based application that will integrate directly with your Magento storefront, allowing you to quickly and easily upload new products or make updates to existing products, and avoid tedious data formatting in spreadsheets and hours of manual data entry. Take a quick TOUR now to learn how ClaraStream can help you save time uploading and managing your product data.
Source:https://www.clarastream.com/2013/06/tips-for-easier-product-uploads-in-magento/
Utilize Magento’s Bulk Product Import Feature:
In addition to giving you the ability to add products individually, Magento also provides bulk import capabilities. By utilizing Magento’s bulk import feature a user can import a large number of products from a single CSV file. While the formatting requirements for bulk product uploads into Magento are very specific, you can easily get an understanding as to how your product must be formatted by exporting existing products out of Magento into a CSV file. It’s important to note that since some of your products may be configurable or have multiple variations the CSV formatting requirements for these products will differ from those without.
Upload Images In Bulk:
Instead of individually uploading images at the product level you can upload images in bulk. Bulk image uploads in Magento are always performed via FTP. Additionally, images must be appropriately labeled according to the SKU and or SKU variation of the product they are associated with.
Add Categories and Attributes In Bulk:
While this does not directly correlate to uploading individual products, taking this step will make the entire import process far more efficient. Preparing all of your attributes and categories for a bulk import before uploading any products will allow you to easily associate products with categories and attributes that you will have already created.
Limit File Size For Bulk Imports:
By keeping the number of products you are uploading to Magento at one time to a reasonable number you will prevent any potential server time outs or delays in successfully uploading all of your product data. Dividing a CSV file with 500 + products into two or three files and running separate uploads will require a little more time on the front end but will invariably prevent future headaches.
Updating Existing Products:
You can also utilize Magento’s bulk import feature to update existing products on your storefront. To make bulk updates to existing products via a CSV file you only need to import the SKU field as well as the field(s) which you would like to update. Once successfully uploaded into Magento your changes will take effect on your storefront.
If you’re looking for a faster and easier way to upload and manage both product data and images in Magento, ClaraStream provides a web based application that will integrate directly with your Magento storefront, allowing you to quickly and easily upload new products or make updates to existing products, and avoid tedious data formatting in spreadsheets and hours of manual data entry. Take a quick TOUR now to learn how ClaraStream can help you save time uploading and managing your product data.
Source:https://www.clarastream.com/2013/06/tips-for-easier-product-uploads-in-magento/
No comments:
Post a Comment