Order request API (php)

Retired Boards Appdev Fulfillment Api

Topic summary

Main issue: Set up an automated order flow from a Shopify store to a supplier’s PHP endpoint so orders use supplier-specific cost prices from a Syncee data feed. OP needs to submit SKU-based orders and was unsure if SKU lookups are supported by Shopify’s APIs.

Supplier API (POST):

  • Params: login, password, ship_name, ship_email, ship_tel, ship_zip, ship_country, ship_address, sku, quantity, mode (test for sandbox only).
  • Response (JSON): status, order_no, item (sku, quantity, price), sub_total, discount, total.
  • Status codes: 1=Ordered, 2=Out of stock, 0=System error.

Key clarification: A reply notes Shopify GraphQL can query product variants by SKU (e.g., productVariants with query “sku:…”), enabling SKU-based matching before calling the supplier API.

Actions/next steps:

  • Use Shopify GraphQL to resolve order line items to variants by SKU, then POST to supplier API with shipping and SKU details.
  • Respect sandbox vs production mode.

Outcome/status: Assistance was offered for integration; OP requested help and pricing. No implementation or resolution yet; discussion remains open.

Summarized with AI on December 29. AI used: gpt-5.
1

Hi all,

wonder If this is possible and If someone want to point me in the right direction.

i have e supplier where i sync products with syncee data feed manager and filter products with sku equal to.

the same supplier has sent a «flow» regarding order requests. I need this setup to work because the data feed contain special cost price pr item. Its not possible to get those prices with manual orders, orders automated to email, export to csv etc.

here is the flow from my supplier.

when i receive a order ( shopify store ) the following setup needs to work:

( i did read somewhere that api request with sku is not supported, but not sure how to move forward )

thanks for any feedback

Suppliers URL (php)

method : post

input parameter :

login : login id

password : password

ship_name : shipping user name

ship_email : shipping user email

ship_tel : shipping user tel no

ship_zip : shipping zip(postal) code

ship_country : shipping country

ship_address : shipping address

sku : SKU

quantity : 1

mode : “test” (Sandbox mode)

** Production Do not use mode=test ,

It is development environment only.

output (JSON):

[

status : “1”,

order_no : “GZD-12345”,

item :

[ “sku”:“sku01” , “quantity”:“1” , “price”:“xxxxx” ] ,

sub_total : “10000”,

discount : “100” ,

total : “100”

]

** status 2 or 0 indicates that the order failed.

It happens when product is Out of stock (2) or system error occurs (0).

Status

1: Ordered

2: Out of stock

0: System error

2

( i did read somewhere that api request with sku is not supported, but not sure how to move forward )

Yes its possible via GraphQL to get product variant SKU
query {productVariants(first: 1, query: “sku:aa-bb-cc-xxl”)

Let me know If you are need help integrating your vendor API

3

Hello and thank you very much for your reply.

Yes, I really need help solving this. Is this something you can help me with? Please let me know if you have time and can resolve this for me and how much this will cost.