MarketPress Importer on MarketPress Lite?

Hello:

I just purchased the MarketPress Premium plug-in. But using MarketPress Lite, I discovered that BlueNet's MarketPress Importer was not completely importing all product information necessary, perhaps this is the reason why my various store page's specific product categories do not display those imported products. I noticed the key difference in the amount of information present in the wp_postmeta table, and here are the differences between a manually-published product, and then a product imported into MarketPress Lite using BlueNet's MarketPress Importer:

--MANUALLY-ENTERED PRODUCT--
TABLE wp_postmeta
meta_id post_id meta_key meta_value
33056 7170 _edit_last 2
33057 7170 _edit_lock 1358444021:2
33058 7170 _thumbnail_id 7169
33061 7170 robotsmeta index,follow
33062 7170 mp_var_name a:1:{i:0;s:0:\\";}"
33063 7170 mp_sku a:1:{i:0;s:0:\\";}"
33064 7170 mp_price a:1:{i:0;d:8.8800000000000007815970093361102044582366943359375;}
33065 7170 mp_is_sale 0
33066 7170 mp_sale_price
33067 7170 mp_track_inventory 0
33068 7170 mp_inventory a:0:{}
33069 7170 mp_price_sort 8.88
33070 7170 mp_product_link
33071 7170 mp_is_special_tax 0
33072 7170 mp_special_tax 0
33073 7170 mp_sales_count 0
33074 7170 mp_shipping a:0:{}
33075 7170 mp_file

--MARKETPRESS IMPORTER IMPORTED PRODUCT--
TABLE wp_postmeta
meta_id post_id meta_key meta_value
33093 7176 mp_var_name a:1:{i:0;s:0:\\";}"
33094 7176 mp_sku a:1:{i:0;s:0:\\";}"
33095 7176 mp_price a:1:{i:0;d:7.769999999999999573674358543939888477325439453125;}
33096 7176 mp_is_sale 1
33097 7176 mp_sale_price a:1:{i:0;i:0;}
33100 7176 _thumbnail_id 7177

and here are the differences in the wp_posts tables, primarily in the guid field:

--MANUALLY-ENTERED PRODUCT--
TABLE wp_postmeta
ID guid
7170 http://www.higrig.com/?post_type=product&p=7170

--MARKETPRESS IMPORTER IMPORTED PRODUCT--
TABLE wp_postmeta
ID guid
7176 http://www.higrig.com/store/products/rotary-test133/

Anyway, I assume the reason I'm not getting a "complete" listing of information in wp_postmeta is due to the fact that I'm using BlueNet's MarketPress importer with MarketPress Lite, instead of MarketPress Premium.

Can anyone verify this, so that future users may know one way or the other?

Thank you :slight_smile:

  • consultnjs

    Yeah an update on this --

    I took a look at an export for the correct xml format required for posts, and since I'm trying to import NEW products, I am unsure of some of information that may be required, namely:

    <wp:post_id></wp:post_id>

    As you can imagine, a product yet-to-be-entered would have an unknown post_id.

    So I tried doing this with the post_id and

    <wp:postmeta>
    			<wp:meta_key>_thumbnail_id</wp:meta_key>
    			<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>

    with the thumbnail_id information blank, and nothing posted into the database or shows up in the Products list inside the WP Admin Dashboard. Obviously, others can import posts from elsewhere, so I would assume that if post_id for a new post already existed in the wp_posts table, that would cause some problems. So I commented out the post_id, pubdate and thumbnail_id nodes. This did not add anything, either, with no errors reported.

    Here is the complete xml file:

    <?xml version="1.0" encoding="UTF-8" ?>
    <!-- This is a WordPress eXtended RSS file generated by WordPress as an export of your site. -->
    <!-- It contains information about your site's posts, pages, comments, categories, and other content. -->
    <!-- You may use this file to transfer that content from one site to another. -->
    <!-- This file is not intended to serve as a complete backup of your site. -->
    
    <!-- To import this information into a WordPress site follow these steps: -->
    <!-- 1. Log in to that site as an administrator. -->
    <!-- 2. Go to Tools: Import in the WordPress admin panel. -->
    <!-- 3. Install the "WordPress" importer from the list. -->
    <!-- 4. Activate & Run Importer. -->
    <!-- 5. Upload this file using the form provided on that page. -->
    <!-- 6. You will first be asked to map the authors in this export file to users -->
    <!--    on the site. For each author, you may choose to map to an -->
    <!--    existing user on the site or to create a new user. -->
    <!-- 7. WordPress will then import each of the posts, pages, comments, categories, etc. -->
    <!--    contained in this file into your site. -->
    
    <!-- generator="WordPress/3.5" created="2013-01-17 18:52" -->
    <rss version="2.0"
    	xmlns:excerpt="http://wordpress.org/export/1.2/excerpt/"
    	xmlns:content="http://purl.org/rss/1.0/modules/content/"
    	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
    	xmlns:dc="http://purl.org/dc/elements/1.1/"
    	xmlns:wp="http://wordpress.org/export/1.2/"
    >
    
    <channel>
    	<title>Higgins Rig Company</title>
    	<link>http://www.higrig.com</link>
    	<description></description>
    	<!--<pubDate>Thu, 17 Jan 2013 18:52:22 +0000</pubDate>-->
    	<language>en-US</language>
    	<wp:wxr_version>1.2</wp:wxr_version>
    	<wp:base_site_url>http://www.higrig.com</wp:base_site_url>
    	<wp:base_blog_url>http://www.higrig.com</wp:base_blog_url>
    
    	<wp:author><wp:author_id>2</wp:author_id><wp:author_login>higgeye</wp:author_login><wp:author_email>higgy@higrig.com</wp:author_email><wp:author_display_name><![CDATA[higgeye]]></wp:author_display_name><wp:author_first_name><![CDATA[Craig]]></wp:author_first_name><wp:author_last_name><![CDATA[Higgins]]></wp:author_last_name></wp:author>
    	<wp:author><wp:author_id>3</wp:author_id><wp:author_login>ben</wp:author_login><wp:author_email>benward022@gmail.com</wp:author_email><wp:author_display_name><![CDATA[ben]]></wp:author_display_name><wp:author_first_name><![CDATA[Ben]]></wp:author_first_name><wp:author_last_name><![CDATA[Ward]]></wp:author_last_name></wp:author>
    
    	<generator>http://wordpress.org/?v=</generator>
    <xhtml:meta xmlns:xhtml="http://www.w3.org/1999/xhtml" name="robots" content="noindex" />
    
    <item>
    		<title>rotary-test140</title>
    		<link>http://www.higrig.com/store/products/rotary-test140/</link>
    		<!--<pubDate>Thu, 17 Jan 2013 03:02:41 +0000</pubDate>-->
    		<dc:creator>higgeye</dc:creator>
    		<guid isPermaLink="false">http://www.higrig.com/store/products/rotary-test140/</guid>
    		<description></description>
    		<content:encoded><![CDATA[This is a test]]></content:encoded>
    		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
    		<!--
    		<wp:post_id></wp:post_id>
    		-->
    		<wp:post_date>2013-01-17 03:02:41</wp:post_date>
    		<wp:post_date_gmt>2013-01-17 03:02:41</wp:post_date_gmt>
    		<wp:comment_status>closed</wp:comment_status>
    		<wp:ping_status>open</wp:ping_status>
    		<wp:post_name>rotary-test123-8</wp:post_name>
    		<wp:status>trash</wp:status>
    		<wp:post_parent>0</wp:post_parent>
    		<wp:menu_order>0</wp:menu_order>
    		<wp:post_type>product</wp:post_type>
    		<wp:post_password></wp:post_password>
    		<wp:is_sticky>0</wp:is_sticky>
    		<category domain="product_tag" nicename="a"><![CDATA[A]]></category>
    		<category domain="product_category" nicename="just-listed"><![CDATA[Just Listed]]></category>
    		<category domain="product_category" nicename="rotary-section"><![CDATA[Rotary Section]]></category>
    	<!--
    	<wp:postmeta>
    			<wp:meta_key>_thumbnail_id</wp:meta_key>
    			<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    	-->
    		<wp:postmeta>
    			<wp:meta_key>robotsmeta</wp:meta_key>
    			<wp:meta_value><![CDATA[index,follow]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_var_name</wp:meta_key>
    			<wp:meta_value><![CDATA[a:1:{i:0;s:0:"";}]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_sku</wp:meta_key>
    			<wp:meta_value><![CDATA[a:1:{i:0;s:0:"";}]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_price</wp:meta_key>
    			<wp:meta_value><![CDATA[a:1:{i:0;d:7.769999999999999573674358543939888477325439453125;}]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_is_sale</wp:meta_key>
    			<wp:meta_value><![CDATA[0]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_sale_price</wp:meta_key>
    			<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_track_inventory</wp:meta_key>
    			<wp:meta_value><![CDATA[0]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_inventory</wp:meta_key>
    			<wp:meta_value><![CDATA[a:0:{}]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_price_sort</wp:meta_key>
    			<wp:meta_value><![CDATA[7.77]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_product_link</wp:meta_key>
    			<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_is_special_tax</wp:meta_key>
    			<wp:meta_value><![CDATA[0]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_special_tax</wp:meta_key>
    			<wp:meta_value><![CDATA[0]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_sales_count</wp:meta_key>
    			<wp:meta_value><![CDATA[0]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_shipping</wp:meta_key>
    			<wp:meta_value><![CDATA[a:0:{}]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_file</wp:meta_key>
    			<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>_wp_trash_meta_status</wp:meta_key>
    			<wp:meta_value><![CDATA[publish]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>_wp_trash_meta_time</wp:meta_key>
    			<wp:meta_value><![CDATA[1358442430]]></wp:meta_value>
    		</wp:postmeta>
    	</item>
    
    </channel>
    </rss>
  • consultnjs

    Okay, further update -- this does work, according to your directions using the WordPress Importer. I had some erroneous stuff in the product information, namely the status tag, which was set to "trash" instead of publish. Now the information publishes and displays in the correct product categories, and shows up on the website in the correct categories.

    I guess the question concerning MarketPress Premium versus Lite is still open concerning BlueNet's MarketPress Importer plug-in, so any input from anyone on this would not only be helpful to me, but anyone else that may run across BlueNet's plug-in and it's use with MarketPress Lite.

    So, let's keep this post open until someone comes around, if that's okay.

    here is the sample XML code I used to add a new post:

    <?xml version="1.0" encoding="UTF-8" ?>
    
    <rss version="2.0"
    	xmlns:excerpt="http://wordpress.org/export/1.2/excerpt/"
    	xmlns:content="http://purl.org/rss/1.0/modules/content/"
    	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
    	xmlns:dc="http://purl.org/dc/elements/1.1/"
    	xmlns:wp="http://wordpress.org/export/1.2/"
    >
    
    <channel>
    	<title>Higgins Rig Company</title>
    	<link>http://www.higrig.com</link>
    	<description></description>
    	<!--<pubDate>Thu, 17 Jan 2013 18:52:22 +0000</pubDate>-->
    	<language>en-US</language>
    	<wp:wxr_version>1.2</wp:wxr_version>
    	<wp:base_site_url>http://www.higrig.com</wp:base_site_url>
    	<wp:base_blog_url>http://www.higrig.com</wp:base_blog_url>
    
    	<wp:author><wp:author_id>2</wp:author_id><wp:author_login>higgeye</wp:author_login><wp:author_email>higgy@higrig.com</wp:author_email><wp:author_display_name><![CDATA[higgeye]]></wp:author_display_name><wp:author_first_name><![CDATA[Craig]]></wp:author_first_name><wp:author_last_name><![CDATA[Higgins]]></wp:author_last_name></wp:author>
    	<wp:author><wp:author_id>3</wp:author_id><wp:author_login>ben</wp:author_login><wp:author_email>benward022@gmail.com</wp:author_email><wp:author_display_name><![CDATA[ben]]></wp:author_display_name><wp:author_first_name><![CDATA[Ben]]></wp:author_first_name><wp:author_last_name><![CDATA[Ward]]></wp:author_last_name></wp:author>
    
    	<generator>http://wordpress.org/?v=</generator>
    <xhtml:meta xmlns:xhtml="http://www.w3.org/1999/xhtml" name="robots" content="noindex" />
    
    <item>
    		<title>rotary-test150</title>
    		<link>http://www.higrig.com/store/products/rotary-test150/</link>
    		<dc:creator>****</dc:creator>
    		<guid isPermaLink="false">http://www.higrig.com/store/products/rotary-test150/</guid>
    		<description></description>
    		<content:encoded><![CDATA[This is a test]]></content:encoded>
    		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
    
    		<wp:comment_status>closed</wp:comment_status>
    		<wp:ping_status>open</wp:ping_status>
    		<wp:post_name>rotary-test150</wp:post_name>
    		<wp:status>publish</wp:status>
    		<wp:post_parent>0</wp:post_parent>
    		<wp:menu_order>0</wp:menu_order>
    		<wp:post_type>product</wp:post_type>
    		<wp:post_password></wp:post_password>
    		<wp:is_sticky>0</wp:is_sticky>
    		<category domain="product_tag" nicename="a"><![CDATA[A]]></category>
    		<category domain="product_category" nicename="just-listed"><![CDATA[Just Listed]]></category>
    		<category domain="product_category" nicename="rotary-section"><![CDATA[Rotary Section]]></category>
    
    		<wp:postmeta>
    			<wp:meta_key>robotsmeta</wp:meta_key>
    			<wp:meta_value><![CDATA[index,follow]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_var_name</wp:meta_key>
    			<wp:meta_value><![CDATA[a:1:{i:0;s:0:"";}]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_sku</wp:meta_key>
    			<wp:meta_value><![CDATA[a:1:{i:0;s:0:"";}]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_price</wp:meta_key>
    			<wp:meta_value><![CDATA[a:1:{i:0;d:7.769999999999999573674358543939888477325439453125;}]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_is_sale</wp:meta_key>
    			<wp:meta_value><![CDATA[0]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_sale_price</wp:meta_key>
    			<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_track_inventory</wp:meta_key>
    			<wp:meta_value><![CDATA[0]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_inventory</wp:meta_key>
    			<wp:meta_value><![CDATA[a:0:{}]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_price_sort</wp:meta_key>
    			<wp:meta_value><![CDATA[7.77]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_product_link</wp:meta_key>
    			<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_is_special_tax</wp:meta_key>
    			<wp:meta_value><![CDATA[0]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_special_tax</wp:meta_key>
    			<wp:meta_value><![CDATA[0]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_sales_count</wp:meta_key>
    			<wp:meta_value><![CDATA[0]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_shipping</wp:meta_key>
    			<wp:meta_value><![CDATA[a:0:{}]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>mp_file</wp:meta_key>
    			<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>_wp_trash_meta_status</wp:meta_key>
    			<wp:meta_value><![CDATA[publish]]></wp:meta_value>
    		</wp:postmeta>
    		<wp:postmeta>
    			<wp:meta_key>_wp_trash_meta_time</wp:meta_key>
    			<wp:meta_value><![CDATA[1358442430]]></wp:meta_value>
    		</wp:postmeta>
    	</item>
    
    </channel>
    </rss>
  • consultnjs

    Hello Kimberly:

    Since I'm not a wordpress "expert" in terms of what is sufficient information to be filed in mp_postmeta table, I'm unsure why it was not working correctly. So what I did instead was added about 15 lines of information to BlueNet's creation to make it work for how I needed. I also altered the CSVisual importation plug-in to empty the wp_mpimporter table. I'll be working on merging these two, if CSVisual's license allows for it. I might monetize this synthesis for a very small amount, and then again, I might provide it for free.

    Because as of right now, the MarketPress Importer by BlueNET does not work as packaged -- it required more meta_key information generated in wp_postmeta table in order to show up on the main category-based pages in the configuration I have inherited from a client.

    I'm a programmer, not a framework guru, so when something does not work right, I'm apt to just go change or customize whatever code is available. I'll publish my changes shortly with a link to my company's website.

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.