Getting hours and notes logged for last 3 weeks.

Meeting with Steve & Cory to update on progress and run plan from yesterday by them.

Finished up with shopify calls. 

Next Steps

1. pull in orders

• create transition invoice
• record the shopify order id
• try and match shopify product to Adilas part for each line... if names match record the shopify product id
• if no match line is left off (this will cause a mismatch between the invoice total and the line totals and flag the invoice so you know something is off.)
• add customer (if no match for name, email, address, phone => create customer)
• add payment
• add button if missing lines to re-pull this order (after shopify product name/adilas part number have been changed to match)

2. Inventory management (PO/Invoice creation)

• grab shopify product id (if don't have, do product lookup by name)
• grab inventory/location id for product variants (by product id) and adjust on-hand qty
• create table to log when missing a product id and qty couldn't be updated. Then build a page to show that information... At this time I don't think we will build anything out to update qty once names have been fixed at this time, but wait until the next sale/po to have them updated.
• ** might want to add a warning message at top of page after PO/Invoice creation to warn user of mismatch and to reference report... but that is just a temporary message that will be gone once they leave the page. Reasoning behind this is it will avoid having to do a full, all shopify product to part number match, but just do those items that are being brought in/sold in real time to make the clean up spread out and more manageable.

* note: need to still determine which fields are being matched together for names in Adilas and Shopify... I will have to play around with this in both systems to see what our options are as needed.

Code review and clean up for what we actually need  for productVariant and getOrders calls.

Adjusting product variant api call to grab the location id/location quantities. Had to go back and adjust original oAuth to request read permissions for locations (didn't think I would need them, but I do).

Converting productVariant data into adilas friendly data. Meeting to give update to Steve & Cory. Looking into what needs to happen for approval process for app to go live. Reading through documentation about inventory counts and how they work (on hand vs reserved vs committed vs available) and which quantities you can adjust through the api. To adjust the inventory we need location id and inventory id - both of which can be pulled from the productVariant call built out already so should be good to work on that call.

Reading through the documentation to see how products interact with inventory and locations, etc... was able to find a way to search for a product by title... but not sure if the title will match with Adilas' part number... was later able to find how product, product variant and inventory items all play and work together. You can only lookup a product by name... but don't have access to inventory quantities... you can only look up product variants by product id, but allows to look up quantities.

Meeting w/ Steve and Cory to give update. Digging in deeper to see if we can pull more information about the individual parts in the order to see if we can get their shopify ids to help with inventory updates when adilas qty changes. Was able to get the ids but those ids don't match up with the shopify inventory ids needed to adjust inventory levels... need to dig deeper to see if the product id does any good for us.

Finished with the api call and now converting the data into Adilas friendly data to use for building transition invoices.

Going through documentation and looking at what information to pull in.

Trying some test GraphQL requests... testing the validation for various types of responses, (Unauthorized, bad request, etc) all give back very different responses so error handling will need to be pretty involved. Was able to make first successful call with Shopify!

Next steps:

• build needed shopify call to fetch the orders... this will allow us to make a single call to get all the information we need, but it will be nested pretty deep with order, customer, payment and product information so it might take a hot min.
• Map customers/products to what we have in the Adilas system
• build out endpoint to update product quantities in shopify when something is sold in Adilas

Continued building out the oAuth process and verifying the nonce, shop name, etc. I am getting stuck on the hmac verification... my encoded string doesn't match up with theirs.

Noticed a warning at the top of the documentation as I was going through the oAuth code that said as of 4/1/25 all new implementations must use GraphQL instead of REST. Started looking through documentation and how it differs all all previous Adilas API integrations have been SOAP or REST... This will have a little bit of a learning curve to get the syntax right on the requests as it is fluid (much more room for error)... but this does give us a lot more control once we get it figured out.

Was able to get process to where I needed to start pushing up live files for the oAuth redirect to data0. Since we have multiple servers, we need to pass in custom params as part of the oAuth so we can get them back to the correct server. Need to test how Shopify chooses to handle these redirect params.

Going through clover oAuth process to see what code we could reuse and started to refactor it to allow for shopify integration.

Working on the Fulfillment Home to accept the incoming Shopify sales via Transitional Invoices

Added Shopify to the 3rd party solutions page and action page. WebPageID 1124. Add in a new logo for Shopify. Merged into master and testing live on data0.

Need to affirm with Alan what key values Shopify requires and update accordingly. 

Going through documentation for the oAuth protocol. Looks like we will have to build it out manually as their libraries aren't compatible with CF

Working on the Shopify 3rd party solution. Verbiage and logo research as well as adding a new WebPageID (1124)

Created a testing store account and started a "Dev App". Added inventory and did test sales to see how the shopify account works.

Meeting with Alan and Michael on how Teams and Shopify connection. We are reducing the connection time from 15 minutes to 5 for better syncing of inventory. I will be starting on the 3rd party solutions page and the Fulfillment page and Alan will be starting on the API with Shopify.

Meeting with Alan on the API integration, we divided duties. I'll be adding in the 3rd party page and meeting with Michael on the Fulfillment Functionality

Looking through endpoints and seeing what they offer and intro meeting with Steve about plan moving forward.