API Developer for Order Fulfillment Project Using VBA

Highlighted
New Member
1 0 0

Seeking API developer for an order fulfillment project. Must be done in VBA.

 

Criteria:

  • Lookup Shipstation export file, which will be saved on computer as .CSV
  • Read Order Number and Tracking Number on the .CSV
  • Query Shopify for orders present on the .CSV by Order Number, NOT by Order ID
  • Update each Open order returned from the query: 1) from Open to Fulfilled status and 2) add tracking number
  • Report back in VBA to user to ensure same number of orders on the Shipstation export were updated in Shopify (IE, none missing)
  • Clear process flow document for future alterations

 

Finished Deliverable:

User opens VBA, points it to a Shipstation .CSV export, hits run. The system takes all orders present on the export, marks them fulfilled, and adds tracking number on Shopify.

  1. User only operates within the VBA to do this process
  2. Clear documentation of how the program works is included so future updates are possible

 

Requisites:

Must have experience with VBA and API from VBA.

API must work by querying Shopify using Order Number, not Order ID as this information does not flow into Shipstation.

 

Timeline:

1/20/20 – 2/15/20

 

Contacting:

If you post your contact information here, I will contact you directly and please be prepared to provide the following within 2 days:

  1. Relevant work experience with BOTH VBA and Shopify API
  2. Recent references
  3. Your location, working hours, and expected availability for this project within the above time period
  4. A fixed cost proposal broken down by task. Include time for revision following a test period and for documenting your process. Estimate high or provide an hours range by task.

Being overly brief here and trying to be the lowest cost option will not work in your favor. Experience and realism will speak volumes.

 

0 Likes
Excursionist
39 1 1

Hi @Thipes 

i am interested in your requirement for API to order Fulfillment using VBA

PM Sent 

please reach me out Through Skype : cis.am3 or email me at Frank@cisinlabs.com

Thanks
Frank 

0 Likes
Tourist
93 0 1

Hi  ,

Hope you're keeping great!

I have send you PM, It would be great if you come over Skype for further discussion .

Skype id- live:jennifer.wcoast

I look forward to your response!

Thanks,
Jennifer 

0 Likes
New Member
3 0 0

Hello Thipes

Hope you are doing good.

 

I have send you PM & looking forward to hearing from you soon.

 

Email Id - markc1150@gmail.com

 

Best Regards

Mark

 

 

 

0 Likes
Shopify Partner
385 0 4

Hello Thipes, 
I am interested and available further to assist. 

Please contact further to share details 


Looking forward to your reply 

 

Regards
Deep 

Expert Shopify Designer | S: deepvyas71 | E: deepvyas71@gmail.com
0 Likes