Description
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.
Technical Requirements
For PartSmart
Develop a API that will POST to the Object: GFCON__Import_Sales_Order__c
With these fields:
Populate GFCON__Order_Source__c with “PartSmart”
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
Quantity
Unit of Measure
PartSmart Picklist Field | GoldFinch API Field Name | Field Help |
|---|---|---|
Id | GFCON__Sales_Order_No__c | What if an Id isn’t available? |
PartSmart User Name / Dealer | GFCON__Id_Customer_No__c | dealer’s Account Id |
Product Id | GFCON__Item_No__c | look up GF Item table |
Quantity | GFCON__Quantity__c | quantity ordered for a specific item |
Unit of Measure (UOM) | GFCON__Id_Item_Unit_of_Measure__c | specify UOM such as each, case, etc. |
For GoldFinch Developer
for Import Sales Order records with Order Source = PartSmart, and processed = false
write code to look at PartSmart_Picklist_JSON__c file and create respective Sales Order and Order Lines.
Table | Field Name | Field Help |
|---|---|---|
Sales Order | Sell-to Customer | |
Order Date | today | |
Shipment Date | today + 7 days | |
….. | ||
External Customer No. | GFCON__Sales_Order_No__c???? | |
Sales Line | Item | GFCON__Item_No__c |
Unit of Measure | EA | |
Quantity | ||
Unit Price | Sales Price???? |
////////////////
Create a Salesforce email address that can accept data into this object.
Add a new value to the Order Source picklist
Value = “PartSmart”
Extract / Download Data
A Yakta user will manually download a CSV File from PartSmart
A Yakta user will send an email to the salesforce email address and attach a CSV File with the following fields:
TBD - We have requested a sample file to review
Transform Data
TBD
Load / Import Data
Add the transformed data to the import_sales_order object.
(Not sure if this is actually / might be the transform step – need to understand what that object does)
Acceptance Criteria
A new sales order has been added to Goldfinch.
This sales order can be allocated to inventory.
How To Guide
Overview
This process improves efficiency by automating the import of PartSmart picklist/orders into GoldFinch.
How to Automatically Send Picklist/Orders to GoldFinch
Download the picklist as a CSV File
There is a quick 20 second explanation how to get this CSV File in this video:
Start at 6:45 https://youtu.be/7plRDX5qd2w?si=iNxXjqZwXcQyg7ZJ&t=405
Save this CSV File to a location you will remember
Email the CSV file to the following email address:
TBD
The Picklist is now added in GoldFinch as a Sales Order.