Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Asked & Answered Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

How to use serialized data co Create Coupon in WooCommerce?

  • June 16, 2021
  • 1 reply
  • 111 views
W

Hello guys,

I have a Zap that creates a Coupon in a WooCommerce website.

I need a custom meta data, and luckily Zapier allows that.

The problem is the format of the data.

The field is serialized, so when I add the entry I need:

a:1:{i:0;a:4:{s:10:"product_id";s:4:"2087";s:8:"quantity";s:1:"1";s:15:"discount_amount";s:3:"100";s:13:"discount_type";s:7:"percent";}}

 

It turns into this in the database:

s:136:"a:1:{i:0;a:4:{s:10:"product_id";s:4:"2087";s:8:"quantity";s:1:"1";s:15:"discount_amount";s:3:"100";s:13:"discount_type";s:7:"percent";}}";

 

It's considered a string and serialized again.

 

I can't find the right format to use, anyone can help with that?

 

 

Thanks

Daniele

Best answer by MarinaH

Hi @wp-ok!

Thanks for the question 👍

Zapier’s Formatter allows for the conversion of Line Item fields to individual fields: https://zapier.com/help/create/format/convert-line-items-into-text-strings

However, that may not help out here and you may need a Code step. The best place to ask for help with your code is http://stackoverflow.com. Just tag your question with a “Zapier” tag and usually there will be folks who are willing to help you out. You can see all the questions that have already been asked here: https://stackoverflow.com/questions/tagged/zapier

Alternatively, where is the data coming from, which app, do you have the option to change the formatting of the data in the trigger app, to get it into a format you can use in the Create Coupon action in WooCommerce? 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

M
Forum|alt.badge.img+9
  • MarinaHZapier Staff
  • Zapier Staff
  • Answer
  • June 17, 2021

Hi @wp-ok!

Thanks for the question 👍

Zapier’s Formatter allows for the conversion of Line Item fields to individual fields: https://zapier.com/help/create/format/convert-line-items-into-text-strings

However, that may not help out here and you may need a Code step. The best place to ask for help with your code is http://stackoverflow.com. Just tag your question with a “Zapier” tag and usually there will be folks who are willing to help you out. You can see all the questions that have already been asked here: https://stackoverflow.com/questions/tagged/zapier

Alternatively, where is the data coming from, which app, do you have the option to change the formatting of the data in the trigger app, to get it into a format you can use in the Create Coupon action in WooCommerce? 

Image: Zappy Awards

The Zappy Awards are back

We're celebrating the Zapier builders making AI transformation happen. Winners get a published story on zapier.com, a trophy, $5,000 cash, and a feature at ZapConnect. Nominate yourself or a peer by July 24th, 2026.

Nominate now
Terms & ConditionsAccessibility statement