Title: Import Functionality?
Last modified: October 17, 2020

---

# Import Functionality?

 *  Resolved [jasonthomasdesign](https://wordpress.org/support/users/jasonthomasdesign/)
 * (@jasonthomasdesign)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/import-functionality-3/)
 * Is there a way to import a spreadsheet to assign Woocommerce product ID’s to 
   a list of posts?

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Matt Pramschufer](https://wordpress.org/support/users/mattpramschufer/)
 * (@mattpramschufer)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/import-functionality-3/#post-13552052)
 * [@jasonthomasdesign](https://wordpress.org/support/users/jasonthomasdesign/) 
   I am sorry but there is no import function built in. But I did just have a customer
   ask the same thing and they came up with this solution
 * > After assigning one so that I could see the format, I exported the posts including
   > all of the related custom variables using: WP CSV Exporter, and I imported 
   > that same data from my filled out spreadsheet (putting the field in a pre-serialized
   > format) using WP Import Export Lite
   > I had to setup a profile to add the custom variables, but it worked like a 
   > champ
 *  Thread Starter [jasonthomasdesign](https://wordpress.org/support/users/jasonthomasdesign/)
 * (@jasonthomasdesign)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/import-functionality-3/#post-13555419)
 * No worries I was able to figure this out on my own.
 * So I used WP All Import, then in the import options, under Custom Fields I used“
   wc_pay_per_post_product_ids” as the Name and set Field Options as Serialized.
   Doing this shows a button called “Click to Specify” under “Value” and it opens
   a pop up with two text boxes, Key & Value. In the Key box you start with the 
   number 0 and in Value you put the Product ID of the Woocommerce product you want
   to protect the page or post with.
 * You can add multiple Woocommerce Products to a post by adding more Keys & Values,
   just make sure you increment the keys by 1. (Example, first key is 0, second 
   key is 1, third key is 2, etc).
 * Thanks for the help! Hope my solution finds others well!
 *  Plugin Author [Matt Pramschufer](https://wordpress.org/support/users/mattpramschufer/)
 * (@mattpramschufer)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/import-functionality-3/#post-13557316)
 * Awesome thanks for the update!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Import Functionality?’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce-pay-per-post/assets/icon-256x256.png?rev=2252656)
 * [Pay For Post with WooCommerce](https://wordpress.org/plugins/woocommerce-pay-per-post/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce-pay-per-post/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce-pay-per-post/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce-pay-per-post/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce-pay-per-post/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce-pay-per-post/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Matt Pramschufer](https://wordpress.org/support/users/mattpramschufer/)
 * Last activity: [5 years, 8 months ago](https://wordpress.org/support/topic/import-functionality-3/#post-13557316)
 * Status: resolved