You can't use this until you register with us!

Description

Obtain order numbers from ManageOrders and store them in MySQL.

Purchasing Options

ManageOrders Order Number to MySQL Loader - $49.99 / month

Available Actions

Download Order Numbers

Retrieve a list of external order ids from a MySQL database and use them obtain the corresponding order numbers from ManageOrders. Store the order numbers in the same MySQL database.

Variables

ManageOrders Parameters
manage_orders_credentials required

Credentials to use to access ManageOrders.


MySQL Parameters
mysql_connection required

Credentials to use to access MySQL.

sql_steps required

Must return a single column containing external order IDs.

update_sql_steps required

SQL Steps to store order numbers. Steps will be repeated for each external order id and order number pair.


Range Parameters
range_start_point required

Datetime stamp indicating the starting point to use to gather external order IDs. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone. Automatically updated after each task execution.

range_end_point_query

SQL Query to use to determine the end point of the data to process. Leave this field blank to process all records with a Datetime stamp after the starting point.