Cloud Cart can pull a list of objects from Salesforce. You could create an object called events and map the event to a sales receipt in QuickBooks. Based on the one you select, Cloud Cart will pull a list of fields to map. In this example, we created a custom object called invoice and we will map the fields.
What does a mapping look like?
Here is an example mapping.
How do I add field mappings?
In this example, our custom object is called Invoice__c. Here are the steps:
- Login to Cloud Cart.
- At the My Connections page, select Salesforce under existing connections.
- Click configure.
- Go to the custom object mapping page.
- Click add.
- Select your custom object, the field name, and the field name to map. In this example, we will map the QB date and Salesforce date fields:
How do I map order items?
Cloud Cart can search the Salesforce order items table for line items. You must map the order ID. Add this mapping:
My custom object has no order items. It has a single product. How do I map the fields?
You can select the order detail field. Refer to the example mapping at the beginning of this article.
How does Cloud Cart filter custom objects?
Cloud Cart can filter custom objects by their creation date or their Salesforce Id. To filter by date, go to the Cloud Cart configure page. Scroll down to Export settings and change the date. To filter by ID, go to the order export tab. In the order list field, enter a comma-separated list of IDs.
How can I map a relationship to the contact or account objects?
In the custom field name drop down, you can select account ID or contact ID. Cloud Cart will map the name, phone, and email from those fields.
If I update my custom object in Salesforce, can Cloud Cart update the order in QuickBooks?
Yes, Cloud Cart can track updates. Login to Cloud Cart. Click configure. Expand the advanced transaction tab and select update orders.
How do I test the field mappings tool?
You can use our order previewer:
- In Cloud Cart, click the settings gear on the right.
- Click reports.
- Select order previewer.
- Enter a date range when the custom objects were created in Salesforce.
In this example, our tool will query for all custom invoices made since 2015.