Title: woocommerce import subsciptions issue
Last modified: August 21, 2016

---

# woocommerce import subsciptions issue

 *  [thedarkcoder](https://wordpress.org/support/users/thedarkcoder/)
 * (@thedarkcoder)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/woocommerce-import-subsciptions-issue/)
 * Hello developers,
 * I have one strange issue, I have woocommerce subscription plugin in my site. 
   I checked how user-subscription syncs. I created script to import subscriptions
   from CSV and I found that in usermeta table, there is one meta_key called “wp_woocommerce_subscriptions”,
   in that, data is stored in fixed format, the format is looking like:
 * `a:1:{s:9:"9999_4050";a:11:{s:10:"product_id";s:4:"4050";s:9:"order_key";s:19:"
   order_51fa4f4503365";s:8:"order_id";i:9999;s:10:"start_date";s:19:"2012-09-06
   00:00:00";s:11:"expiry_date";i:0;s:8:"end_date";i:0;s:6:"status";s:6:"active";
   s:17:"trial_expiry_date";i:0;s:15:"failed_payments";i:0;s:18:"completed_payments";
   a:1:{i:0;s:19:"2012-09-06 00:00:30";}s:16:"suspension_count";i:0;}}`
 * in the first line there is “9999_4050” is combination of two ids, first one is
   orderid, second is subscriptiotype’s post id.
    It is working for me until the
   first id remains to 4 digit, but when it becomes 5 digits say “10000_4050”, the
   record not showing on subscriptions listing.
 * can anyone tell me how this structure filter and how can I resolve my issue? 
   Please help me to get rid of this.
 * Thanks,
    Nirav

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

 *  [urukai](https://wordpress.org/support/users/urukai/)
 * (@urukai)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/woocommerce-import-subsciptions-issue/#post-3985375)
 * Hello Nirav
 * On the search for a solution to import existing subscriptions in a CSV, I came
   across your post. The serialized array contains keys (the combination of orderid
   and subscription type’s id). Now if the array gets serialized, this key is saved
   as
 *     ```
       ... s:9:"9999_4050"; ...
       ```
   
 * if the orderid is higher, then the length of the string changes:
 *     ```
       ... s:10:"10000_4050"; ...
       ```
   
 * Maybe this can help you.
 * I need to import subscriptions into my woocommerce environment. How did you achieve
   this? Which tables are involved? In my user-meta-table, I could not find any 
   records with the key “wp_woocommerce_subscriptions”.
 * Thanks for your help
 * uruk
 *  [Digitally Cultured](https://wordpress.org/support/users/digitally-cultured/)
 * (@digitally-cultured)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/woocommerce-import-subsciptions-issue/#post-3985376)
 * Hi, I’m also looking for a way to import subscriptions into Woo Commerce, preferably
   using a .csv.
 * Are they any plugins available? OP, do you have any tips?

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

The topic ‘woocommerce import subsciptions issue’ is closed to new replies.

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [subscriptions](https://wordpress.org/support/topic-tag/subscriptions/)
 * [user](https://wordpress.org/support/topic-tag/user/)

 * 2 replies
 * 3 participants
 * Last reply from: [Digitally Cultured](https://wordpress.org/support/users/digitally-cultured/)
 * Last activity: [12 years, 4 months ago](https://wordpress.org/support/topic/woocommerce-import-subsciptions-issue/#post-3985376)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics