Corporate Order Importer
The Corporate Order Importer allows you to create multiple orders, with multiple shipping addresses for one single billing customer. The billing customer who is paying for all the orders will only see one charge for the total amount. Please watch the tutorial video or read the following text to learn more about the Corporate Order Importer tool.
1. Navigate to the Settings > Import/Export > Corp. Order Importer.
2. Click Import Corporate Orders from the left navigation.
3. Click Download Sample File to download the spreadsheet we will use.
In the sample file, you will want to filll out the shipping address information and the order details for each order. Each order will only take one line in the Excel spreadsheet. There is room for up to 12 unique SKUs per line (order).
|NickName||Free form text. Nickname for the shipping address.|
|BirthDate||The birthdate of the customer. Format is in: MM/DD/YYYY. If the year is 00-29, it will add 20. If the year is 30-99, it will add 19.|
|FirstName*||The name of the recipient customer.|
|LastName*||The last name of the recipient customer|
|Company||Company of the recipient (optional).|
|City*||Shipping destination city|
|StateCode||The two-digit state code. For example, California = CA.|
|ZipCode*||Recipient customer ZipCode|
|Phone*||Customer phone number|
|Customer email address|
|isPickup||Indicates whether the order is a pickup order or a shipping order. Format is in: 0 = not pickup and 1 = pickup.|
|PickupLocation Code||This is the code attached to your pickup location. Typically this is 'Default' if you have not changed the code when setting up your pickup location.|
|OrderNotes||Special instructions or notes for your fulfillment provider|
|GiftMessage||Message that can be sent over to your fulfillment provider to be included with the order.|
|SKU (1-12)||The product SKU. This must match the SKU that you have set up in Vin65 exactly.|
|SKUQty||Numeric quantity for the SKU - Cannot be 0|
|SKUPrice||Price of the product. You will want to build any discounts into the price here.|
*Mandatory Fields: FirstName, LastName, Address, City, ZipCode, Phone.
1. Navigate to Settings > Import/Export > Corp. Order Importer in your Admin Panel.
2. Click on the green Import Corporate Order button on the left.
To work through the process of creating and charging your corporate orders, you will be directed through a serries of tabs within the import window:
The General tab is the first tab in the Corporate Order process. On this tab, you will select the billing customer and fill in the shipping information for the orders.
1. Start by selecting your billing customer (the contact being charged for all the orders) by clicking on Select A Contact. The billing customer must already exist in your customer database. You cannot add a new billing customer from the Corporate Order Importer tool.
2. Name your shipment to help make it easier to find historical corporate orders.
3. Fill out the shipping options that will be used to charge all of the orders in this coporate batch. You can only pick one strategy and one shipping type for all th e orders in an upload. Orders will be charged shipping based on the individual orders' shipping states (unless a flat rate is used). Orders specified as pickup will not be charged a shipping rate.
4. Click on Browse to load your spreadsheet.
5. Click Save & Next to upload the spreadsheet into the Corporate Order Importer tool to proceed onwards.
The Orders tab allows you to review and edit any of the orders before they are finalized.
1. You can review and edit the orders by clicking the pencil icon next to the customer's name. You can also preview the final order with taxes and shipping costs by clicking the magnifying glass next to the customer's name.
2. Once all your orders have been reviewed, you may click Next to continue to the Order Processing tab.
The Order Processing tab is where you are able to mass create finalized versions of all the orders in your batch. These orders will have the order details finalized but will not yet charge the customer.
1. To begin finalizing the orders in your batch, click the Start check mark.
2. You will be given a breakdown of those that were successful and those that had an error being created. Ensure that you go back and address any of the orders that failed and fix incorrect customer details, product invnetory, etc. Once an order has been created, it will not be created again so you can re-run the Order Processing tab once you have adjusted the errors.
3. Once all your orders have processed successfully, you can click Next to continue to the Credit Card tab.
The Credit Card tab allows you to add the credit card that the billing customer would like to have charged for these orders.
1. Select your payment type: Credit Card.
2. If the billing customer has one or more credit cards saved on file, you will be able to only select one of these cards. Otherwise, you may choose to enter a new card number for a one-time use (the card will not be saved on file and will only be used for the corporate order). An alternative option is to add a new card to be saved on file for the customer.
3. If you are adding a new card, you will want to fill out the card type, number, expiry date and the name on the card.
4. Once you have entered the credit card information that you wish to charge, click Next to proceed to the Charge Order tab.
The Charge Order tab is where you will charge the billing customer's card for all the orders.
1. Now that you have created hold orders and selected a credit card to charge, you are ready to process your corporate batch. Please remember that any orders that you have not yet created will not be charged, so make sure all the orders have been created without errors.
2. You will see a sentence that reads. "there are X orders for a total charge of $xx.xx. Charge $xx.xx?". This outlines the total number of successfully created orders in the batch and the total combined value of the orders. To charge the customer's credit card, you will want to click the credit card icon or text that reads, "Charge $xx.xx?". This will charge the billing customer's card only once for the total value of all the orders.
3. Now you have created your orders and charged the customer, the next three tabs allows you to send the billing customer an email, review the payment or view a summary of the order batch. At this point you have basically finished processing these Corporate Orders.
The Email tab allows you to download an Excel summary of the orders that were charged as well as gives you the option to send an order confirmation email to the billing customer.
The Payment tab displays the single credit card transaction for the total value of all orders. A successful charge will have a success status of yes. If you wish to reference the transaction in your Payment Gateway you can use the number in the trans: field.
The Summary tab allows you to review the stats for the corporate order that you have processed.
Below is a list of some fields you will see under the summary tab of the Corporate Order Importer tool.
|Contact||The billing customer's name.|
|Name||The name of your corporate order batch.|
|Total Charges||The total amount charged for all orders. This will be the amount charged to the billing customer's credit card.|
|Total # of Orders||The total number of orders in your corporate order batch. This includes Processed, Errors and Unprocessed orders.|
|Processed Orders||The number of orders that were sucessfully processed and charged.|
|Errors||The number of orders that had an issue being processed.|
|Unprocessed||The number of orders that remain unprocessed|
Corporate orders are a batch of orders charged to a single billing customer. Each order will be a separate order in Vin65. You can review processed corporate orders under the Store > Orders section by looking up the billing customer's first and last names. All the orders will be under their order history with each recipient as a separate alternate biling address. If you need to refund or cancel any of the orders, you will do this on a per order level. Please visit our documention on processing Refunds.
You can also view past batches that you have setup from the corporate orders section; Settings > Import/Export > Corp. Orders. On the left you will find search parameters for the first and last name of the biling customer or the shipment name.