Best way to upload products to Magento?
-
The import/export tool Magento has is really disappointing, especially when it comes to uploading images. Creating products manually is very time consuming. Could anyone recommend a method to upload products through a feed, is there any plugins etc?
-
I looked at Magneto many years ago and I think it was one that was kind of spun off of oscommerce. If that is true there is a plug-in called easy populate that lets you do just as Monica suggested. Even if not Magneto is so widely used now there has to be a plugin for it. Easy populate allowed you to download or upload files via CSV files which can be easily made in Excel or OpenOffice.
Hope it helps,
Don
-
If I am not mistaken, you can upload spreadsheets. If you can export your products from your current platform into a CSV you can manipulate the field names to be able to import them to Magento. I would do a test export from Magento to get the correct field names. If your images are on a CDN or File Server you should be able to add the file name and description to fields on the spreadsheet. I haven't worked with Magento in awhile, so this info might be outdated. Good luck!
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Best site Template, Structure, etc. for SEO
If I were to spin up a new site what do people recommend as the best template, services, etc. Do you have an example of the perfect structure, I want to point my team to an example page and say - This is perfect, do this but for our product (structure, content amount, etc) Thank you,
On-Page Optimization | | Jamesmcd030 -
How can I write unique and seductive product descriptions about multiple, very similar products?
We are an eCommerce store who sell personalised phone cases, macbook covers, mugs and the like. Our target market is primarily 16-25 and female. We're in the process of redesigning our website www.mrnutcase.com and we desperately need some more enticing product descriptions before the redesign goes live. The problem is that most of our products are exactly the same. For example iPhone 5 case, iPhone 5S Case etc. At the moment our product descriptions are almost the same, but written in a slightly different way. Not only is this dangerous in terms of duplicate content, but it's also extremely boring for the user. With our users being young and female, writing about boring technical specifications isn't going to cut it with the crowd. Obviously, i want each of our pages to rank in Google so I don't want to NoIndex or canonicalize any pages or anything. How can I write unique and enticing product descriptions for very similar products? Would appreciate any ideas! Thanks, Danny
On-Page Optimization | | DannyNutcase0 -
Getting the Titles and Headings Right on Product Pages. Userbility vs SEO
Hey Mozzers, I am optimising a chaotic section of the site including many similar products. Writing unique content etc. The titles and urls were all over the place so my first job was to tidy them up so I could make some sense of the situation, especially as sometimes they didn't even match! I should point out were on Magento, so product name = Both the Heading and Title of the page, the meta title can be set separately. When i refer to title I mean both <title>and <h1></strong><br /><br />Before they existed as such<br />URL: domain.com/200-x-0-5-g-rs-232-balance.html<br />TItle: PC-1234 200 x 0.5g x 0.3 RS-232 Balance<br /><br />This format was (Product Code, Capacities, Resolutions, Accuracy, Product Title)<br /><br />The issue was all 60 products in a page followed this format. Navigating through the page was a nightmare and was just a jumble of numbers and highly confusing even to me who learnt what they all mean, especially when you had 8 products from the same range you got presented with<br /><br />APC-1234 200 x 0.5g x 0.3 RS-232 Balance<br />APC-1235 500 x 1g x 0.3 RS-232 Balance<br />APC-1236 1000 x 2g x 0.3 RS-232 Balance<br />APC-1238 5000 x 10g x 0.3 RS-232 Balance<br />APC-1239 10000 x 15g x 0.3 RS-232 Balance<br />APC-1210 20000 x 25g x 0.3 RS-232 Balance<br />APC-1211 50000 x 50g x 0.3 RS-232 Balance</p> <p>I changed them to something more user friendly.<br /><br />URL: domain.com/200g-precision-balance.html<br />Title: 200g Precision Balance<br /><br />This has seen the following benefits<br />- URL is now clear and means something to the user<br />- Product titles are easy to navigate and the page is more pleasing to the eye<br />- The jumble of numbers in the title are now all labelled and shown below each product listing in bullet point so the user can see the basic spec of a product without having to decipher any titles<br /><br />Upon reflection I has a couple of concerns I was hoping you could discuss, I am wondering if I have made the titles too simple.<br />1) I have no product code in the title<br />We have our own products manufactured and sell existing brands with their own product codes. Some of these can be lengthy. Adding them makes them hard to the eye and the page looked cramped.<br /><br />The codes are listed beneath each product title on category pages and on a list on the actual product page, but no where in the titles. <br /><br />2)None of our products have a brand listed in the title<br />None of the products on the site had brand names in anything but the images when i started and as such it snuck under my radar. But should i pre-fix all titles with a brand name?<br /><br />Should </p> <p>URL: domain.com/200g-precision-balance.html<br />Title: 200g Precision Balance</p> <p>become</p> <p>URL: domain.com/BRAND1-200g-precision-balance.html<br />Title: BRAND1 200g Precision Balance<br /><br />My instinct tells me to change things to include brands as its useful to the customer and should have an SEO benefit, but to leave out product codes as they are accessible to the customer where they are now and dont make things messy and unreadable.<br /><br />As always, thanks for the input!</p></title>
On-Page Optimization | | ATP0 -
Creative ways to dramatically increase content on ecommerce category pages?
I need to signficantly boost the content on the category pages on my ecommerce website. Currently, they're pretty thin, with some only having approx 50 words of unique content. In the past, I've intentionally kept the content on these pages quite light, to keep the aesthetic a certain way. It's a fashion-based site, so it's very much about the visual. However, with the introduction of Panda, I need to change this mindset. But, there must be slightly more creative ways to boost the content to stop the pages looking too text heavy. I'm not talking hidden text or anything, but ways to break it up in different blocks on the page to make it look natural/relevant, while keeping it looking great. Anyone have any good ideas? Or, any links to ecommerce sites that have employed brilliant methods?
On-Page Optimization | | Coraltoes770 -
Add content as blog post or to product pages?
Hi, We have around 40 products which we can produce plenty of in-depth and detailed "how to"-type pieces of content for. Our current plan is to produce a "How to make" style post for each as a long blog post, then link that to the product page. There's probably half a dozen or more of these kind of blog posts that we could do for each product. The reason why we planned on doing it like this is that it would give us plenty of extra pages (blog posts) on their own URL which can be indexed and rank for long tail keywords, but also that we can mention these posts in our newsletter. It'd give people a new page full of specific content that they can read instead of us having to say "Hey! We've updated our product page for X!", which seems a little pointless. Most of the products we sell don't get very many searches themselves; Most get a couple dozen and the odd few get 100-300 each, while one gets more than 2,000 per month. The products don't get many searches as it's a relatively unknown niche when it comes to details, but searches for the "categories" these products are in are very well known (Some broad terms that cover the niche get more than 30,000+ searches a month in the UK and 100,000+ world wide) [Exact].
On-Page Optimization | | azu25
Regarding the one product with more than 2,000 searches; This keyword is both the name of the product and also a name for the category page. Many of our competitors have just one of these products, whereas we're one of the first to have more than 6 variations of this product, thus the category page is acting like our other product pages and the information you would usually find on our product pages, is on the category page for just this product. I'm still leaning towards creating each piece of content as it's own blog post which links to the product pages, while the product pages link to the relevant blog posts, but i'm starting to think that it may be be better to put all the content on the product pages themselves). The only problem with this is that it cuts out on more than 200 very indepth and long blog posts (which due to the amount of content, videos and potentially dozens of high resolution images may slow down the loading of the product pages). From what I can see, here are the pros and cons: Pro (For blog posts):
1. More than 200 blog posts (potentially 1000+ words each with dozens of photos and potentially a video)..
2. More pages to crawl, index and rank..
3. More pages to post on social media..
4. Able to comment about the posts in the newsletter - Sounds more unique than "We've just updated this product page"..
5. Commenting is available on blog posts, whereas it is not on product pages..
6. So much information could slow down the loading of product pages significantly..
7. Some products are very similar (ie, the same product but "better quality" - Difficult to explain without giving the niche away, which i'd prefer not to do ATM) and this would mean the same content isn't on multiple pages.
8. By my understanding, this would be better for Google Authorship/Publishership.. Con (Against blog posts. For extended product pages):
1. Customers have all information in one place and don't have to click on a "Related Blog posts" tab..
2. More content means better ability to rank for product related keywords (All but a few receive very few searches per month, but the niche is exploding at an amazing rate at the moment)..
3. Very little chance of a blog post out-ranking the related product page for keywords.. I've run out of ideas for the 'Con' side of things, but that's why I'd like opinions from someone here if possible. I'd really appreciate any and all input, Thanks! [EDIT]:
I should add that there will be a small "How to make" style section on product pages anyway, which covers the most common step by step instructions. In the content we planned for blog posts, we'd explore the regular method in greater detail and several other methods in good detail. Our products can be "made" in several different ways which each result in a unique end result (some people may prefer it one way than another, so we want to cover every possible method), effectively meaning that there's an almost unlimited amount of content we could write.
In fact, you could probably think of the blog posts as more of "an ultimate guide to X" instead of simply "How to X"...0 -
Important keywords in product names
Hi! among other we sell motorcycle clothing, which you can buy as a set (both jacket and pants) or single piece. Currently we name the products with the labeling in the beginning, e.g: Motorcycle pants R2000, Motorcycle jacket R2000, Motorcycle kit R2000 Motorcycle pants R4000, Motorcycle jacket R4000, Motorcycle kit R4000 This is causing keyword stuffing and cannibalization in the category pages as all the product names include important keywords. On the other hand it would be beneficial to keep the labeling in the name for search queries for the exact product. What be your recommendations? I tend to take the labeling away.
On-Page Optimization | | RomiSverige0 -
How do you avoid duplicate content when you sell products that are produced by other manufacturers?
I have a packaging product site, and they sell products from various manufacturers. What can we do with the product detail pages? As of now, the client has copy pasted content straight from the "About" sections on the manufacturers' sites. Obviously, those manufacturers want my client to sell their products, and the products need to be described. How much of a no-no is this copy pasting, and how can I fix it?
On-Page Optimization | | lhc670 -
How unique do product descriptions need to be?
I'm rewriting approximately 10,000 product descriptions, but for feasability it's useful to sometimes reuse some of the phrases that are there (and on other websites as they come straight from the manufacturer -eg. key features), how unique does the content have to be - are we talking 100%, 75%, 50% for it to be effective in google? Same question goes for the product title! Many thanks.
On-Page Optimization | | ewanr0