Use data from a MySQL table to create orders with SanMar.
Read data from MySQL and create orders with SanMar.
Variables
MySQL database where the order data is located.
Table name, in schema.table format, where the the order data is located.
Datetime stamp indicating the starting point of data to use to create new orders. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.
Credentials to connect to SanMar's Web Services.
SQL code used to locate and extract data needed to create new orders. Refer to slide out help for more information.
SQL code used to create a new unique purchase order number. Refer to slide out help for more information.
SQL code used to create a new unique attention header. Refer to slide out help for more information.
SQL code used record the response from the SanMar server after a new order creation attempt. Refer to slide out help for more information.
Name of the individual or Company that will receive the order.
First line of the shipping address. Use the following abbreviations: ST, AVE, RD, DR, BLVD.
Second line of the shipping address. Typically a floor, suite or apartment number.
City where the order will be shipped.
Two letter abbreviation for the state where the order will be shipped.
Zip code where the order will be shipped. For example, 00321 or 98007-1156.
Is the address specified a personal residence?
Method used to ship the order. For example, UPS.
Email address to receive order updates.