Already a customer? 
Log In
Register
Members
Home
Add Reply
Add Topic
Topic RSS
8:13 pm
QuoteHi. I have a couple questions about your shopping plugin.
I have a client who wants to put an automotive site up that specializes in clutches. We've looked at Zen Cart, but it really doesn't thrill me. I have a fairly extensive background in Wordpress, and I'd like to explore WP solutions.
The client has a large catalog currently, and it will likely expand considerably in the future. THey also need a very definite categorization structure. Similar to
Ford
Explorer pickup
1999
4.0 lliter
Item
Related item
5.0 liter
2000
2001
Another model…
I think you get the picture.
I'm pretty sure this can be accomplished with your product. But, I can't see them putting one item in at a time. Can you offer up any suggestions about how items could be handled in a mass maintenance fashion?
Thanks.
Wally Day
P.S. – We are on a tight timeline here, so I would appreciate a prompt reply.
There's not a mass import function with the Market theme, however you can do a mass import through your web host's MySQL admin area.
If you're not familiar with that, you could probably find someone on Guru.com to do that for you for less than $50. It's not difficult if you're proficient with Excel. Most of the work is in arranging the data and columns to prepare for the import. The import part is easy.
10:49 pm
I'm a pretty good database guy and programmer, although not all that familiar with MYSQL (SQL in general is not an issue). I assume, then, that Market Thame has good database documentation. If that's available, then I should be OK with the import. I think the actual “post/product” should be easy - I'm just not yet up-to-snuff regarding the category/tag structure. Does Wordpress.org have good documentation regarding the Excel -> database formatting?
Like I eluded to earlier, documentation within Market doesn't cover MySql mass importing. If you're skilled at database stuff, then you should be ok. Just open up the posts table in Wordpress, look at the fields it wants, and create a .csv file that gives the correct data to each of the columns. I'd enter a product first through the product manager to get an idea of what it looks like, then copy the structture to the rest of your records.
11:03 am
Thanks for the response. Three questions…
1) Does Market Theme introduce new tables/coulmns to the database? Or, does it just use the current schema and utilize the custom fields functionality?
2) Depending on the answer to #1, is Market Theme's database mods/additions documented anywhere? Can I look at them before proceeding?
3) This is a question open to anyone who might read this… Does anyone know of an editor (like PHPMyAdmin) that is tailored to Wordpress? Like some kind of super Wordpress database query utility?
Thanks
No, it does not introduce new tables or columns. Market integrates only as a theme. The Market Product Manager is uploaded to the /plugins folder, and that does not change the database either
The database is still the same structure as the standard install, because nothing is changed.
Hope this helps.
1:32 pm
So, tell me if I'm thinking right here…
1) Add a couple products using the standard WP user interface.
2) Export the items to an XML file.
3) Import the XML file into Excel so I have a template to start with.
4) Add products to the Excel file until I'm done with the "catalog".
5) Export the Excel file to XML
6) Import the XML file into the WP installation.
I'm guessing it would probably be easiest to upload all of the items and the use a plugin like "Batch Categories" to assign categories to the items in bulk.
Hmmmm, now that I think about it… are we creating posts here or pages? Does market theme create a page for each item?
Yes, you are thinking correctly. Your outline above is almost exactly as I do them.
When I do an import however, I save the Excel file as either a .CSV or a semicolon separated .TXT file. The MySQL admin actually allows for quite a few types of importing formats, and you can even customize the separation character to be something else such as a pipe "|" or the tab character.
To answer your last question, Market creates a post for each product — not a page. A product post has a product "flag" value that lets the system know to display the post in product format, rather than regular text post format.
I hope this helps.
This Wordpress plugin will work for you with Markettheme. It's called CSV Importer. You can find it in the plugins section through Wordpress. I use it to import product post pages. You can use the custom fields option through the plugin. It will support the custom fields used by Markettheme. Works great. I use it: http://wordpress.org/extend/pl…..-importer/
I hope that helped!
Tams
Thanks for listing the step by step instructions how to do bulk uploading.
Would it be possible if you could highlight the fields/columns that MUST be filled in in order for the files to upload to the WP database?
Can you explain how I force CSV Importer to import the file into a Market Theme Product Post. At the moment it creates a normal post.
Thanks.
gordy01 — Your product posts are just categorized incorrectly. They need to be in a sub-category under your top level "Products" category. (You select your top level "Products" category in the Market Theme settings area. Review the "readme.html" file in your download package for help on how to categorize.
seorocks – The best way for you to see all that's affected, is to install your theme, set things up, and then just add a single product. (This way you can mimic that format to your entire product list.)
Then, if you log into your database using your MySQL interface (through your hosting account control panel) — You will see all the places that update when a new product post is added.
The tables to look at are:
wp_posts
wp_postmeta
and then
wp_term_relationships (which relates the post ID to the category ID used in the "terms" table)
I hope this helps.
12:25 am
January 10, 2012
Offline
I know this is a bit old, newbie at this. Got the data uploaded via the wordpress plug in, CSV Importer. But none of them go in as products. reading the above I am still a bit confused as to what value I need to add to to have them go in as products, add prices and the rest I would be happy to do by hand…one at a time.
This plugin works but it wasn't designed for this theme specifically so it has regular post values like author and excerpts.
I only used
The post name, description and category. Using the terms: csv_post_title, csv_post_post and csv_post_category
what would I put for it to go in as a product?
Would appreciate any and all help.
Most Users Ever Online: 47
Currently Online:
18 Guest(s)
Currently Browsing this Page:
2 Guest(s)
Member Stats:
Guest Posters: 428
Members: 2253
Moderators: 1
Admins: 1
Forum Stats:
Groups: 1
Forums: 4
Topics: 2986
Posts: 16051
Newest Members: americanrelicsnet, karmacoast, Allsed, deleteduser, shanm, slidesketch
Moderators: Market Admin (5052)
Administrators: Market Admin (5052)
