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
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
-
What is the best SEO way to categorize products on an ecommerce site
What is the best way for SEO to set up categories for an ecommerce site selling beauty products. I have currently built my product categories so that if a person looks under the hydration category they find our body lotion, but also if they look under the body section of products they also will find the same body lotion. Is this a problem for SEO? I think it helps the customer find the product.
Intermediate & Advanced SEO | | Kuhliff0 -
DeepCrawl Calls Incomplete Open Graph Tags and Missing Twitter Cards An Issue. How important is this?
Hi, Let me first say that I really like the tool DeepCrawl. So, not busting on them. More like I'm interested in the relative importance of two items they call as "Issues." Those items are "Incomplete Open Graph Tags" and "No Valid Twitter Cards." They call this out on every page. To define it a bit further, I'm interested in the importance as it relates to organic search.I'm also interested in there's some basic functionality we may have missed in our Share42 implementation. To me, it looks like the social sharing buttons work. Also, we use Share42 social sharing buttons, which are quite functional. If it would help, I could private message you an example url. Thanks! Best... Mike
Intermediate & Advanced SEO | | 945011 -
Manage category pages and duplicate content issues
Hi everybody, I am now auditing this website www.disfracessimon.com
Intermediate & Advanced SEO | | teconsite
this website has some issues with canonicals and other things. But right now I have found something that I would like to know your opinion. When I was checking parts of the content in google to find duplicate content issues I found this: I google I searched: "Chaleco de streck decorado con botones" and found First result: "Hombre trovador" is the one I was checking -> Correct
The following results are category pages where the product is listed in. I was wondering if this could cause any problem related with duplicated content. Should I no index category pages or should I keep it?
The first result in google was the product page. And category pages I think are good for link juice transfer and to capture some searchs from Google. Any advice? Thank you0 -
Articles marked with "This site may be hacked," but I have no security issues in the search console. What do I do?
There are a number of blog articles on my site that have started receiving the "This site may be hacked" warning in the SERP. I went hunting for security issues in the Search Console, but it indicated that my site is clean. In fact, the average position of some of the articles has increased over the last few weeks while the warning has been in place. The problem sounds very similar to this thread: https://productforums.google.com/forum/#!category-topic/webmasters/malware--hacked-sites/wmG4vEcr_l0 but that thread hasn't been touched since February. I'm fearful that the Google Form is no longer monitored. What other steps should I take? One query where I see the warning is "Brand Saturation" and this is the page that has the warning: http://brolik.com/blog/should-you-strive-for-brand-saturation-in-your-marketing-plan/
Intermediate & Advanced SEO | | Liggins0 -
Ecommerce SEO - Indexed product pages are returning 404's due to product database removal. HELP!
Hi all, I recently took over an e-commerce start-up project from one of my co-workers (who left the job last week). This previous project manager had uploaded ~2000 products without setting up a robot.txt file, and as a result, all of the product pages were indexed by Google (verified via Google Webmaster Tool). The problem came about when he deleted the entire product database from our hosting service, godaddy and performed a fresh install of Prestashop on our hosting plan. All of the created product pages are now gone, and I'm left with ~2000 broken URL's returning 404's. Currently, the site does not have any products uploaded. From my knowledge, I have to either: canonicalize the broken URL's to the new corresponding product pages, or request Google to remove the broken URL's (I believe this is only a temporary solution, for Google honors URL removal request for 90 days) What is the best way to approach this situation? If I setup a canonicalization, would I have to recreate the deleted pages (to match the URL address) and have those pages redirect to the new product pages (canonicalization)? Alex
Intermediate & Advanced SEO | | byoung860 -
WP plugins not updating - unable to remove
how can i update plugins if i get this: Downloading update from http://downloads.wordpress.org/plugin/akismet.2.5.7.zip… Unpacking the update… Installing the latest version… Removing the old version of the plugin… Could not remove the old plugin. Plugin update failed. same for AIOSEO
Intermediate & Advanced SEO | | Ezpro90 -
How To Best Close An eCommerce Site?
We're closing down one of our eCommerce sites. What is the best approach to do this? The site has a modest link profile (a young site). It does have a run of site link to the parent site. It also has a couple hundred email subscribers and established accounts. Is there a gradual way to do this? How do I treat the subscribers and account holders? The impact won't be great, but I want to minimize collateral damage as much as possible. Thanks.
Intermediate & Advanced SEO | | AWCthreads0 -
Where would the SEO juice go if I have a wordpress site hosted by godaddy?
I am planning on moving my website to a wordpress that is hosted by godaddy. I am wondering where the SEO juice that my website has already gained would go. Would it go to godaddy when I make the move instead?
Intermediate & Advanced SEO | | SierraPCB0