| Table of Contents | ||
|---|---|---|
|
...
Overview
A user needs the ability to automatically send the PartSmart Picklist (Sales Order) to GoldFinch so they do not need to manually enter a sales order into GoldFinch.
Setups
On the Dealer’s Contacts, populate Email Address, which is typically the user’s email address.
Technical Requirements
For PartSmart
...
Develop a API that will POST to the Object: GFCON__Import_Sales_Order__c
...
For every item that could be ordered by PartSmart, set up to Sales Prices for CAD and USD.
Ending Date should be far in the future.
Price Type = All Account
Minimum Quantity = 1
...
Steps to send PartSmart Picklists to GF
...
Error Conditions
PartSmart User Name is not set up
Dealer Account is not set up
Item is not set up
Sales Prices are not set up
Configurations
PartSmart post their picklists to GoldFinch a public URL.
A new Import Sales Order record will be created with these fields:
Populate GFCON__Order_Source__c with “PartSmart”Populate GFCON__Id_Customer_No__c with the dealer’s account Id.
Picklist JSON file should go to PartSmart_Picklist_JSON__c
The Picklist JSON File should include these values:
Id
PartSmart User Name / Dealer
Product Id
The Product ID value must match a ProductCode value in GoldFinch.
If it does not, provide a lookup to map the PartSmart Product ID to GoldFinch ProductCode
Quantity
Unit of Measure
Description
Quantity
As soon as a new Import Sales Order is created with PartSmart_Picklist_JSON__c != null:
Use PartSmart User Name to look up Contact, to populate
Customer Name
Id Customer No.
Populate Customer PO No. with Picklist Id
Order Date = today’s date
Populate Import Sales Line
PartSmart Picklist Field | GoldFinch API Field Name | Field Help | Id | |
|---|---|---|---|---|
Product Id | GFCON__Item _ No__clook up GF Item table. | |||
Quantity | Quantity | GFCON__Quantity__c | quantity ordered for a specific item | |
Description | Description | |||
Item Unit of Measure (UOM) | GFCONItem__Idr.Base_Item_Unit_of_Measure__c | specify UOM such as each, case, etc. |
For GoldFinch Developer
Develop API endpoint for the GFCON__Import_Sales_Order__c object
for Import Sales Order records with Order Source = PartSmart, and processed = false
write code that looks at PartSmart_Picklist_JSON__c file and does the following
Does the related GFCON__Import_Sales_Line__c object need to be populated first?
create sales orders
create sales lines
...
Table
...
Field Name
...
Field Help
...
GFCON__Import_Sales_Line__c
...
GFCON__Item_No__c
...
populated from the API?
...
GFCON__Quantity__c
...
populated from the API?
...
GFCON__Id_Item_Unit_of_Measure__c
...
populated from the API?
...
Order
...
OrderNumber
...
Auto Number
...
AccountId
...
map from
Object: GFCON__Import_Sales_Order__c
Field: GFCON__Id_Customer_No__c
...
Shipping Information
...
Can this be looked up based on the Account Id?
...
Order Date
...
today
...
Shipment Date
...
today + 7 days
...
Pricebook2Id
...
should this be “Standard Price Book” ?
...
OrderReferenceNumber
...
map from
Object: GFCON__Import_Sales_Line__c
Field: GFCON__Sales_Order_No__c
...
GFERP__Sales_Line__c
...
GFERP__Item__c
...
map from
Object: GFCON__Import_Sales_Line__c
Field:
GFCON__Item_No__c
...
GFCON__Quantity__c
...
map from
Object: GFCON__Import_Sales_Line__c
Field:
GFCON__Quantity__c
...
GFCON__Id_Item_Unit_of_Measure__c
...
map from
Object: GFCON__Import_Sales_Line__c
Field:
GFCON__Id_Item_Unit_of_Measure__c
...
GFERP__Unit_Price__c
...
Is this automatically updated based on the Price Book?
Or does this need to be sent through the API from PartSmart?
...
r.Name | ||
Unit Price | look up Sales Price table using Currency and Item. Currency is from Account. If blank, Company Setup. If blank, CAD |
Process Records
Once the values have been imported, you can view and update the data before the Sales Order records are created.
In the Not Processed View:
Select the individual Import Sales Order record(s) to convert into a Sales Order.
If no records are selected, GoldFinch will process all of the records where the Processed field is NOT checked.
After selecting the Import Sales Order records, click the Create Sales Order button to process the data.
After a Sales Order has been successfully created, the Processed field on the Import Sales Order record will be checked and set to true.
Opens image in full screenOpen
...
Error Resolution
If GoldFinch encounters any errors while creating a Sales Order from the Import Sales Order record:
The GF Sales Order will not be created until the errors have been resolved.
The Processed field on the Import Sales Order record will be False.
Use the Not Processed View to see all Import Sales Order records with an error message.
The Error will be populated into the Error Text field on the Import Sales Order record.
Use the Error Text field to correct the Import Sales Order record and resolve the error.
Once all errors have been resolved, rerun the process by selecting the Import Sales Order record and clicking the Create Sales Order button.
Mass Delete
If necessary, multiple Import Sales Order records may be deleted at the same time:
In the Not Processed View:
Select the individual Import Sales Order record(s) you want to delete.
If no records are selected, GoldFinch will delete all the records where the Processed field is NOT checked.
After selecting the Import Sales Order records, click the Mass Delete button to process the data.