Moz Q&A is closed.
After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.
Using WP All Import csv import plugin for wordpress to daily update products on large ecommerce site. Category naming and other issues.
-
We have just got an automated solution working to upload about 4000 products daily to our site. We get a CSV file from the wholesalers server each day and the way they have named products and categories is not ideal.
Although most of the products remain the same (don't need to be over written)
Some will go out of stock or prices may change etc.
Problem is we have no control over the csv file so we need to keep the catagories they have given us. Might be able to create new catgories and have products listed under multiple categories?
If anyone has used wp all import or has knoledge in this area please let me know. I have plenty more questions but this should start the ball rolling!
Thanks in advance mozzers
-
Hey Guys thanks for the help Yes I am using woocomerce.
The import is all set up and runs all by it''s self using cron
The problem is the category field in csv cant be changed (at least not by the wholesaler ) so we would need to write some code to make that happen.
I might try adding some new categories and and still keep the old ones (otherwise) wordpress/woocommerce wouldnt know where to put the products.
-
http://www.webgility.com/woocommerce.php
http://www.woothemes.com/product-category/woocommerce-extensions/
http://www.storeapps.org/product/smart-manager/
http://docs.woothemes.com/document/woocommerce/
http://winkpress.com/ecommerce/shopping-cart/woocommerce/
http://winkpress.zippykidcdn.com/wp-content/uploads/2012/05/woocommerce-product-variations.png
This is a photo of wink press please notice the content delivery network and name of the host
This may be the best a choice for e-commerce on WordPress as far as hosting goes so much you get tons of high quality perks plus outstanding private cloud hosting along with it being backed by rack space, but meant for WordPress only. For e-commerce you can't go wrong with Zippy kid
https://www.zippykid.com comes with a free Cdn along with the new SPDY protocol to make using SSL Certs lightning fast
You might just need an import tool like this
http://www.woothemes.com/products/sequential-order-numbers-pro/
This controls inventory, customers, orders and ties into the Financials
http://demo.storeapps.org/wp-admin/admin.php?page=smart-manager-woo-demo
http://docs.woothemes.com/document/woocommerce/
This does it all and ties into github a fantastic way to update your website constantly with this type of information managed WordPress posts that integrate with. github Zippy kid and WP engine. Each is fantastic
https://github.com/woothemes/woocommerce
I think you can stop looking however and put away your spreadsheets if you can
http://www.webgility.com/woocommerce.php
I hope I have been of help,
Thomas
-
are you using Woo commerce? I think you are trying to import the csv file like a website however I have no idea what you're actually doing.
Where are you importing it into what software plug-in?
There are better methods including ones that will check with an API determine if the price or stock has changed and update accordingly. woo Commerce is the best word press e-commerce software on the market in my opinion. It has a lot of plug-ins go to woothemes.com search for woo commerce and look at all of the plug-ins that offers.
I have done what you're talking about with another e-commerce website and it was fairly simple however it seems like you have more politics in play and they expect you to use what they have created.
I would need to play by play of software to software exactly what's occurring exactly what you're doing to import exactly what e-commerce plug-in you're using?
There's a lot of questions.
Sincerely,
Thomas
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
-
How to enable lost trailing slash redirection in WordPress with Yoast plugin
Hi, We have lost the non-slash to slash URL redirection in our WP site. We are using Yoast SEO. All the settings are normal and we have enabled the related code in .htaccess too. Still we couldn't able to find why we lost. Please help. Thanks
Intermediate & Advanced SEO | | vtmoz0 -
Using the same image across the site?
Hi just wondering i'm using the same image across 20 pages which are optimized for SEO purposes. I was wondering is there issues with this from SEO standpoint? Will Google devalue the page because the same image is being used? Cheers.
Intermediate & Advanced SEO | | seowork2140 -
Same product in different categories and duplicate content issues
Hi,I have some questions related to duplicate content on e-commerce websites. 1)If a single product goes to multiple categories (eg. A black elegant dress could be listed in two categories like "black dresses" and "elegant dresses") is it considered duplicate content even if the product url is unique? e.g www.website.com/black-dresses/black-elegant-dress duplicated> same content from two different paths www.website.com/elegant-dresses/black-elegant-dress duplicated> same content from two different paths www.website.com/black-elegant-dress unique url > this is the way my products urls look like Does google perceive this as duplicated content? The path to the content is only one, so it shouldn't be seen as duplicated content, though the product is repeated in different categories.This is the most important concern I actually have. It is a small thing but if I set this wrong all website would be affected and thus penalised, so I need to know how I can handle it. 2- I am using wordpress + woocommerce. The website is built with categories and subcategories. When I create a product in the product page backend is it advisable to select just the lowest subcategory or is it better to select both main category and subcategory in which the product belongs? I usually select the subcategory alone. Looking forward to your reply and suggestions. thanks
Intermediate & Advanced SEO | | cinzia091 -
Handling of product variations and colours in ecommerce
Hi, our site prams.net has 72.000 crawled and only 2500 indexed urls according to deep crawl mainly due to colour variations (each colour has its own urls now). We now created 1 page per product, eg http://www.prams.net/easywalker-mini and noindexed all the other ones, which had a positive effect on our seo. http://www.prams.net/catalogsearch/result/?q=002.030.059.0 I might still hurt our crawl budget a lot that we have so many noindexed pages. The idea is now to redirect 301 all the colour pages to this main page and make them invisible. So google do not have to crawl them anymore, we included the variations in the product pages, so they should still be searchable for google and the user. Does this make sense or is there a better solution out there? Does anyone have an idea if this will likely have a big or a small impact? Thanks in advance. Dieter
Intermediate & Advanced SEO | | Storesco0 -
Robots.txt - Do I block Bots from crawling the non-www version if I use www.site.com ?
my site uses is set up at http://www.site.com I have my site redirected from non- www to the www in htacess file. My question is... what should my robots.txt file look like for the non-www site? Do you block robots from crawling the site like this? Or do you leave it blank? User-agent: * Disallow: / Sitemap: http://www.morganlindsayphotography.com/sitemap.xml Sitemap: http://www.morganlindsayphotography.com/video-sitemap.xml
Intermediate & Advanced SEO | | morg454540 -
Multiple Ecommerce sites, same products
We are a large catalog company with thousands of products across 2 different domains. Google clearly knows that the sites are connected. Both domains are fairly well known brands - thousands of branded searches for each site per month. Roughly half of our products overlap - they appear on both sites. We have a known duplicate content issue - both sites having exactly the same product descriptions, and we are working on it. We've seen that when a product has different content on the 2 sites, frequently, both pages get to page 2 of the SERPs, but that's as far as it goes, despite aggressive white hat link building tactics. 1. Is it possible to get the same product pages on page 1 of the SERPs for both sites? (I think I know the answer...) 2. Should we be canonicalizing (is that a word?) products across the sites? This would get tricky - both sites have roughly the same domain authority, but in different niches. Certain products and keywords naturally rank better on 1 site or the other depending on the niche.
Intermediate & Advanced SEO | | AMHC0 -
Create new subdomain or new site for new Niche Product?
We have an existing large site with strong, relevant traffic, including excellent SEO traffic. The company wants to launch a new business offering, specifically targeted at the "small business" segment. Because the "small business" customer is substantially different from the traditional "large corporation" customer, the company has decided to create a completely independent microsite for the "small business" market. Purely from a Marketing and Communications standpoint, this makes sense. From an SEO perspective, we have 2 options: Create the new "small business" microsite on a subdomain of the existing site, and benefit from the strong domain authority and trust of the existing site. Build the microsite on a separate domain with exact primary keyword match in the domain name. My sense is that option #1 is by far the better option in the short and long run. Am I correct? Thanks in advance!
Intermediate & Advanced SEO | | axelk0