Note: This action will only submit individual records when triggered. If you need to import historical data, please look into our CSV Uploader or contact support@wickedreports.com for assistance importing your historical data.

If Wicked Reports does not integrate directly with your Payment Process or Order Management System, we offer the ability to create orders in Wicked Reports with an HTTP Post.

HTTP Posts are common in CRMs and easy to setup.  You can typically trigger them through Automation options in your CRM (Infusionsoft Campaigns, ActiveCampaign Automations, etc.)

To Create Orders using HTTP Post, you must first enable this feature in your Authorizations under Orders Data



Once enabled, you'll be able to copy the URL for your HTTP Posts



URL:  https://api.wickedreports.com/createorder/<clientname>

How To Create Orders

The HTTP Post has a series of Name/Value Pairs which will be used to create the Orders:

Name values are Case Sensitive, so be careful

  • OrderID:  //REQUIRED Unique OrderID, typically from the source Order system but can by any UNIQUE value
  • OrderDateTime: //REQUIRED Date & Time the order was placed in format MM/DD/YYYY HH:MMAM/PM (Correct formatting example: "9/26/2016 20:15" or "9/26/2016 8:15PM"
    • You can use “NOW” for the current Date/Time
    • Date format is important.  Using a date and time like this "4-10-17 0:00" will not work. (You need to use / not -)
    • You are welcome to use the 24 hour formatting (20:15 for example) or 12 hour time formatting (8:15PM for example)
    • An example of a correctly formatted CREATEDATE field would be: "9/29/2016 8:15PM" (MM/DD/YY HH:MMAM/PM)
  • OrderTimeZone:  //REQUIRED Timezone of Contact Date/Time (EST Timezone="UTC-5", CST Timezone="UTC-6", etc)  ** these values change based on Daylight Savings Time
    • This is the timezone the date is represented in, NOT the timezone of the contact.  If your CRM system shows orders in EST, then you would use UTC-5
    • these values change based on Daylight Savings Time  
  • OrderTotal: //REQUIRED Amount of the Order
  • ProductID: Unique ProductID, typically from the source Order System
    • If the Product does not yet exist, this will be the id of the newly created product.
  • ProductName: Product Name.  
    • If the product does not yet exist, this will be the name of the newly created product.
  • CustomerEmail: //REQUIRED Email address of the Customer
  • CustomerState:  State of Billing Address
  • CustomerCountry:  Country of the Billing Address
  • SubscriptionID: If this order is part of a subscription, each order will have the same "SubscriptionID" which is unique to that Order.  This ID represents a series of payments for one individual customer. This is NOT a Product ID to be used for multiple orders for multiple customers.  If the order is not for a recurring subscription, this field should be empty
  • OrderSystem: //REQUIRED a reference field of the source system that the orders were pulled from.  This should be only ONE WORD and contain no spaces. For example "PayPal" or "AuthorizeNET"
  • IsRefund : //REQUIRED YES/NO.  If the HTTP Post is for an Order, then the value is NO.  If the HTTP Post is for a Refund, the value is YES

Important Information

  • If the order being created uses an email address which does not exist in Wicked Reports, we will create one.  We cannot have orders for contacts which do not exist.
  • If the Product used in the HTTP post does not exist in Wicked Reports, we will create the product using the provided ProductID and ProductName and associate this order with it.
  • Timezones change with Daylight savings time.  For example, EST (Eastern Standard Time) is UTC-5 part of the year and UTC-4 part of the year.  If you are setting up an automation that will run continuously, you will need to be aware of this and make sure your automation updates when daylight savings time occurs.

Sample HTML Web Form for Inserting Orders using HTTP Post


You can use this code sample, referencing the specifications above and the examples below, to create a web form that will manually create Order HTTP Post.


<form id="form-submit-test" action=" 
https://api.wickedreports.com/createorder/<YourClientName>" method="post" target="_blank">
  OrderID:<br>
  <input type="text" name="OrderID" value=""><br>
  OrderDateTime:<br>
  <input type="text" name="OrderDateTime" value=""><br>
  OrderTimeZone:<br>
  <input type="text" name="OrderTimeZone" value=""><br>
  OrderTotal:<br>
  <input type="text" name="OrderTotal" value=""><br>
  ProductID:<br>
  <input type="text" name="ProductID" value="0"><br>
  ProductName:<br>
  <input type="text" name="ProductName" value=""><br>
  CustomerEmail:<br>
  <input type="text" name="CustomerEmail" value=""><br>
  CustomerState:<br>
  <input type="text" name="CustomerState" value=""><br>
  CustomerCountry:<br>
  <input type="text" name="CustomerCountry" value=""><br>
  SubscriptionID:<br>
  <input type="text" name="SubscriptionID" value=""><br>
  OrderSystem:<br>
  <input type="text" name="OrderSystem" value=""><br>
  IsRefund:<br>
  <input type="text" name="IsRefund" value=""><br><br>
<button type="submit" form="form-submit-test" value="Submit">Submit</button>
</form>


Example of an HTTP Post to Create an Order

Examples using Infusionsoft HTTP Post

Create a One-Time order for a specific Day/Time

* Remember that the Post URL will be specific for you, do not use what's shown in image



Create a One-Time order for the current Day/Time

* Remember that the Post URL will be specific for you, do not use what's shown in image


Create a Subscription Order for a specific Day/Time

* Remember that the Post URL will be specific for you, do not use what's shown in image


  • Remember:  Product information is NOT required for an order to be created.
  • Timezones change with Daylight savings time.  For example, EST (Eastern Standard Time) is UTC-5 part of the year and UTC-4 part of the year.  If you are setting up an automation that will run continuously, you will need to be aware of this and make sure your automation updates when daylight savings time occurs.