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




Description

Use data from a MySQL database to create orders and jobs in Syncore.


Purchasing Options



Available Actions

Create Purchase Orders

Execute an SQL Query against a MySQL database and use the results to create or update purchase orders in Syncore.


Variables

Source Parameters
db required

Database with data to to process.

table_name required

Name of the table with data to process, in schema.table format.

sql_query required

SQL Query to obtain data to process.

post_sql_query

SQL Steps to run after entries in Syncore have been created or updated.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.


Range
pointer required

Datetime stamp indicating the starting point of the data to process. This field will automatically be updated after each increment is processed.

end_query required

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Destination Parameters
syncore_connection required

Credentials to use to connect to Syncore.

skip_error required

Continue processing subsequent data if an error occurs.

errors_table_name

Optional name of the table, in schema.table format, where Syncore errors will be stored.


Create Sales Orders

Execute an SQL Query against a MySQL database and use the results to create or update sales orders in Syncore.


Variables

Source Parameters
db required

Database with data to to process.

table_name required

Name of the table with data to process, in schema.table format.

sql_query required

SQL Query to obtain data to process.

post_sql_query

SQL Steps to run after entries in Syncore have been created or updated.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.


Range
pointer required

Datetime stamp indicating the starting point of the data to process. This field will automatically be updated after each increment is processed.

end_query required

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Destination Parameters
syncore_connection required

Credentials to use to connect to Syncore.

skip_error required

Continue processing subsequent data if an error occurs.

errors_table_name

Optional name of the table, in schema.table format, where Syncore errors will be stored.


Create Payments for Sales Orders

Execute an SQL Query against a MySQL database and use the results to create payments for sales orders in Syncore.


Variables

Source Parameters
db required

Database with data to to process.

table_name required

Name of the table with data to process, in schema.table format.

sql_query required

SQL Query to obtain sales order payments to update.

post_sql_query

SQL Steps to run after entries in Syncore have been created or updated.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.


Range
pointer required

Datetime stamp indicating the starting point of the data to process. This field will automatically be updated after each increment is processed.

end_query required

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Destination Parameters
syncore_connection required

Credentials to use to connect to Syncore.

skip_error required

Continue processing subsequent data if an error occurs.

errors_table_name

Optional name of the table, in schema.table format, where Syncore errors will be stored.


Create Drop Ship Jobs

Execute an SQL Query against a MySQL database and use the results to create or update drop ship jobs in Syncore.


Variables

Source Parameters
db required

Database with data to to process.

table_name required

Name of the table with data to process, in schema.table format.

sql_query required

SQL Query to obtain data to process.

post_sql_query

SQL Steps to run after entries in Syncore have been created or updated.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.


Range
pointer required

Datetime stamp indicating the starting point of the data to process. This field will automatically be updated after each increment is processed.

end_query required

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Destination Parameters
syncore_connection required

Credentials to use to connect to Syncore.

skip_error required

Continue processing subsequent data if an error occurs.

errors_table_name

Optional name of the table, in schema.table format, where Syncore errors will be stored.


Create Store Jobs

Execute an SQL Query against a MySQL database and use the results to create or update store jobs in Syncore.


Variables

Source Parameters
db required

Database with data to to process.

table_name required

Name of the table with data to process, in schema.table format.

sql_query required

SQL Query to obtain data to process.

post_sql_query

SQL Steps to run after entries in Syncore have been created or updated.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.


Range
pointer required

Datetime stamp indicating the starting point of the data to process. This field will automatically be updated after each increment is processed.

end_query required

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Destination Parameters
syncore_connection required

Credentials to use to connect to Syncore.

skip_error required

Continue processing subsequent data if an error occurs.

errors_table_name

Optional name of the table, in schema.table format, where Syncore errors will be stored.


Create Purchase Order Line Items

Execute an SQL Query against a MySQL database and use the results to create or update purchase order line items in Syncore.


Variables

Source Parameters
db required

Database with data to to process.

table_name required

Name of the table with data to process, in schema.table format.

sql_query required

SQL Query to obtain data to process.

post_sql_query

SQL Steps to run after entries in Syncore have been created or updated.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.


Range
pointer required

Datetime stamp indicating the starting point of the data to process. This field will automatically be updated after each increment is processed.

end_query required

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Destination Parameters
syncore_connection required

Credentials to use to connect to Syncore.

skip_error required

Continue processing subsequent data if an error occurs.

errors_table_name

Optional name of the table, in schema.table format, where Syncore errors will be stored.


Create Sales Order Line Items

Execute an SQL Query against a MySQL database and use the results to create or update sales order line items in Syncore.


Variables

Source Parameters
db required

Database with data to to process.

table_name required

Name of the table with data to process, in schema.table format.

sql_query required

SQL Query to obtain data to process.

post_sql_query

SQL Steps to run after entries in Syncore have been created or updated.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.


Range
pointer required

Datetime stamp indicating the starting point of the data to process. This field will automatically be updated after each increment is processed.

end_query required

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Destination Parameters
syncore_connection required

Credentials to use to connect to Syncore.

skip_error required

Continue processing subsequent data if an error occurs.

errors_table_name

Optional name of the table, in schema.table format, where Syncore errors will be stored.


Update Job Statuses

Execute an SQL Query against a MySQL database and use the results to update job statuses in Syncore.


Variables

Source Parameters
db required

Database with data to to process.

table_name required

Name of the table with data to process, in schema.table format.

sql_query required

SQL Query to obtain jobs to update.

post_sql_query

SQL Steps to run after entries in Syncore have been created or updated.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.


Destination Parameters
syncore_connection required

Credentials to use to connect to Syncore.

skip_error required

Continue processing subsequent data if an error occurs.

errors_table_name

Optional name of the table, in schema.table format, where Syncore errors will be stored.


Update Sales Order Statuses

Execute an SQL Query against a MySQL database and use the results to update sales order statuses in Syncore.


Variables

Source Parameters
db required

Database with data to to process.

table_name required

Name of the table with data to process, in schema.table format.

sql_query required

SQL Query to obtain sales orders to update.

post_sql_query

SQL Steps to run after entries in Syncore have been created or updated.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.


Destination Parameters
syncore_connection required

Credentials to use to connect to Syncore.

skip_error required

Continue processing subsequent data if an error occurs.

errors_table_name

Optional name of the table, in schema.table format, where Syncore errors will be stored.


Update Purchase Order Statuses

Execute an SQL Query against a MySQL database and use the results to update purchase order statuses in Syncore.


Variables

Source Parameters
db required

Database with data to to process.

table_name required

Name of the table with data to process, in schema.table format.

sql_query required

SQL Query to obtain purchase orders to update.

post_sql_query

SQL Steps to run after entries in Syncore have been created or updated.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.


Destination Parameters
syncore_connection required

Credentials to use to connect to Syncore.

skip_error required

Continue processing subsequent data if an error occurs.

errors_table_name

Optional name of the table, in schema.table format, where Syncore errors will be stored.


Create Contacts

Execute an SQL Query against a MySQL database and use the results to create or update contacts in Syncore.


Variables

Source Parameters
db required

Database with data to to process.

table_name required

Name of the table with data to process, in schema.table format.

sql_query required

SQL Query to obtain data to process.

post_sql_query

SQL Steps to run after entries in Syncore have been created or updated.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.


Range
pointer required

Datetime stamp indicating the starting point of the data to process. This field will automatically be updated after each increment is processed.

end_query required

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Destination Parameters
syncore_connection required

Credentials to use to connect to Syncore.

skip_error required

Continue processing subsequent data if an error occurs.

errors_table_name

Optional name of the table, in schema.table format, where Syncore errors will be stored.