How to Bulk Upload Products in Magento 2
Importing new products and editing the existing in Magento sucks. It'south ok, you can acknowledge information technology.
I doubt anyone enjoys exporting and importing files back and forth. Information technology takes And then MUCH TIME.
It's a huge and dreary task, yet yous can't do information technology sloppily – SEO, customer experience, conversions, all depend to a big extent on product descriptions and details.
For all of yous who feel there's gotta be a better way, we put together this commodity. We'll go over everything that'south incorrect with the standard way of importing products to Magento and requite you lot iii alternative ways to do it.
The aim is to save you time and effort, minimize mix-ups and let y'all to focus on more than important things.
The standard way: CSV import
For a step-by-step tutorial, encounter this commodity by SiteGround
As you know, it's a straightforward method, although not the simplest ane. Probably the all-time thing virtually it is that it' gratis and you practise information technology in your Magento admin.
It'south basically creating 1 sample product in the admin, exporting it in tabular array format to use equally a template, filling in all products in the aforementioned way and importing information technology back again.
astralwebinc.com
The issues with standard product import in Magento
Error identification
When uploading the CSV file, Magento might detect some errors like missing or mismatched attribute, and duplicate columns or descriptions. You have to be actress careful to put each attribute in the right column because otherwise they go all mixed up.
Magento says there are X number of errors, but doesn't assist you place and fix them. Sometimes, you'll accept to go over the whole file, find them yourself, fix them and upload information technology again.
Product prototype uploads
Calculation product images usually is washed separately from the product detail import thanks to Magento's file management. It's not recommended to include pictures in the CSV file because it oftentimes messes upwardly the whole import.
Editing a product is complicated
Editing products is a hurting. Having to go over each spec individually for each product is enough to make you cringe.
All in all, as much as Magento users are not afraid of a little challenge, even bones tasks can take too much fourth dimension. I mean, if you savor clicking through so many fields and sub-menus, go ahead, why not. ☺
If you lot, on the other paw, don't have time or nerve to waste, tertiary-political party tools can help you. They tin can be more comfortable work environment for such tasks. Below, we'll bear witness y'all how you can do it with the alternative solutions we institute for you.
Nosotros chose them because they solve the most common problems of the standard import. We figured, why not simplify things and leave more time for not-and then-wearisome tasks?
Importing products with Sheetly
Sheetly is a tool that simplifies production management in Magento. It works and pretty much feels similar a familiar spreadsheet, but smarter.
You lot enter all production details in it (for as many products as you want) and it syncs with your Magento to show them ready in the admin. Then, you tin can publish them to your store.
How is it different from the CSV file?
- No need for exports and imports, it's integrated with your Magento store and then y'all work in information technology and see information technology in the admin. You still have control over when they go live, though.
- Since it'due south connected to your admin, if you add any new categories or attributes, they'll exist fix to use in Sheetly, too. It saves time from exporting new tables all the time.
- It shows where the errors are (which particular jail cell) and points you at how to fix them so you won't have to do a file over because you switched attribute columns, for example.
- It has a elevate & drop picture manager that makes product epitome upload easier.
- Editing products is faster because you can freely motion beyond rows and columns, re-create, paste and then on. All changes are saved immediately just like in an Excel worksheet.
Yes, it doesn't fill out your production info for you. You lot notwithstanding accept to enter all details simply at least the sheet is ready and ready.
What'south the catch
No catch, in fact, their clients dearest how much time and effort Sheetly saves them that transfers to other crucial tasks. Ane formulated information technology every bit:
This is the solution that enables me to aggrandize my store into new markets easily.
When the manual nuts don't take up all your energy, yous can grow your business.
Go on in mind that it'southward a paid tool based on the number of products you manage. Effort it in beta hither.
Import/ Export Products Extension
Another find in the Magento Market place is this extension by developer Scott Bolasevich.
Information technology does piece of work with files, but on steroids. It covers all kinds of products, editing, tier pricing and custom fields.
Highlights:
- No need for FTP client when importing.
- Image direction is taken care of – you tin can upload via a link or from server; change images to existing products; fix galleries, etc.
- No needo ready attributes and categories in accelerate – they're automatically created at impo if not found.
- Patently, users are happy with the back up provided single-handedly by the developer.
Cons:
If there's something, information technology still uses a CSV and it's a paid solution (ane-fourth dimension buy).
Fast Products Import Extension
The third tool is another extension establish on Magento Connect, Fast Products Import by EcommerceTeam. It works for both importing new products and editing existing ones just like the first two.
Pros:
- At that place's a cron option for scheduled imports (automation everywhere!)
- It works past using direct mySQL queries.
- You can ready a Correction factor, which helps merge entries that seem like only for a simple typo.
- You lot tin can also set default attribute values to use in import in case a value is missing.
- Information technology has a broad range of customization options for the data entries like advent and number modifications.
Cons:
It'due south a one-fourth dimension buy tool with only vi months of support, which can be a fleck of a trouble.
What do you lot think?
So here are 3 quite different approaches to product import in Magento. If you don't make changes regularly, probably the standard one is ok and yous don't need anything more.
Nonetheless, if it gives you lot headaches and it'southward been the reason you notwithstanding oasis't taken Christmas sweaters downward from your store, bank check out these solutions – they might actually make your life easier.
If yous need more help with running your store, Metrilo has analytics, CRM and email marketing tool designed especially for Magento. Try it for free.
Source: https://www.metrilo.com/blog/alternative-ways-to-import-products-in-magento
0 Response to "How to Bulk Upload Products in Magento 2"
Post a Comment