Amazon Seller SKU missing on Orders API call

Highlighted
Tourist
8 0 3

Hi,

I'm importing orders into my accounting system and it appears that there is no meaningful linkage available for items originating from Amazon.  For orders originating in the Shopify, the SKU field holds the necessary item cross-reference (Perfect!).  For those from Amazon, all that appears in the export are the two values in bold that don't seem to be connected to anything. 


Perhaps I'm missing something obvious.  If anyone could shed some light on this for me, it would be greatly appreciated.

Thanks,

Scott


API Version 2020-04 (JSON export converted to XML):

 

<item type="object">

  <id type="number">4791895916680</id>

  <variant_id type="null">

  </variant_id>

  <title type="string">My special widget that I offer for sale</title>

  <quantity type="number">1</quantity>

  <sku type="null">

  </sku>

  <variant_title type="null">

  </variant_title>

  <vendor type="null">

  </vendor>

  <fulfillment_service type="string">manual</fulfillment_service>

  <product_id type="null">

  </product_id>

  <requires_shipping type="boolean">true</requires_shipping>

  <taxable type="boolean">true</taxable>

  <gift_card type="boolean">false</gift_card>

  <name type="string">My special widget that I offer for sale</name>

  <variant_inventory_management type="null">

  </variant_inventory_management>

  <properties type="array">

    <item type="object">

      <name type="string">Amazon Order Item ID</name>

      <value type="string">51982890421834</value>

    </item>

  </properties>

  <product_exists type="boolean">false</product_exists>

  <fulfillable_quantity type="number">1</fulfillable_quantity>

  <grams type="number">0</grams>

  <price type="string">234.00</price>

  <total_discount type="string">0.00</total_discount>

  <fulfillment_status type="null">

  </fulfillment_status>

  <price_set type="object">

    <shop_money type="object">

      <amount type="string">234.00</amount>

      <currency_code type="string">USD</currency_code>

    </shop_money>

    <presentment_money type="object">

      <amount type="string">234.00</amount>

      <currency_code type="string">USD</currency_code>

    </presentment_money>

  </price_set>

  <total_discount_set type="object">

    <shop_money type="object">

      <amount type="string">0.00</amount>

      <currency_code type="string">USD</currency_code>

    </shop_money>

    <presentment_money type="object">

      <amount type="string">0.00</amount>

     <currency_code type="string">USD</currency_code>

    </presentment_money>

  </total_discount_set>

  <discount_allocations type="array">

  </discount_allocations>

  <admin_graphql_api_id type="string">gid://shopify/LineItem/4791895916680</admin_graphql_api_id>

  <tax_lines type="array">

    <item type="object">

      <title type="string">Sales tax</title>

      <price type="string">15.80</price>

      <rate type="number">0.0675214</rate>

      <price_set type="object">

        <shop_money type="object">

          <amount type="string">15.80</amount>

          <currency_code type="string">USD</currency_code>

        </shop_money>

        <presentment_money type="object">

          <amount type="string">15.80</amount>

          <currency_code type="string">USD</currency_code>

        </presentment_money>

      </price_set>

    </item>

  </tax_lines>

</item>

0 Likes
Highlighted
New Member
2 0 0

We are after the Amazon Order Item Id.

 

But only seem to get the ASIN back in the response:

 

"properties": [{
                            "name": "ASIN",
                            "value": "B086QZMN37"
                            }],
 
Is there any settings that are determining this ?
0 Likes
Highlighted
New Member
1 0 0

Were you ever able to resolve this?  I'm having the same issue and cannot find an answer anywhere.  Thanks.

0 Likes
Highlighted
Tourist
8 0 3

No.  Doesn't seem to be a priority for the Shopify API yet.  I'm really surprised that this is not on the export.  ASIN is useless for integration as it is not manageable  by the merchant.  Merchants use the Seller SKU to cross-reference with their own items.  Not providing this on the export kills the integration. 

0 Likes
Highlighted
Shopify Expert
4175 29 400

I resolved this for sellers in this way. Hold on to your hats, you won't believe it!

 

Yes Amazon functions with the ASIN and that screws up Shopify. So what to do! We throw Amazon orders into emails with the details. We know orders are being placed into Shopify by Amazon, but we cannot process them yet. So we regularly pull emails from Amazon. With those, we get the orders, the line items (SKUs) and we can start to rebuild Humpty Dumpty. At the end of playing with orders from Amazon, in emails, and then matching to Shopify, we can actually comprehend what has gone on, and get those orders to the third-party fulfillment center! And there is trickery there too as fulfillment with Amazon requires things to be tidied up there too.

So the moral of the story is this. I have a high volume client that sells a lot of stuff on Shopify and Amazon as sales channels. The Amazon to Shopify sales channel it pretty much hot garbage due to Amazon, and you can thus resort to emails to glue things together. So you write an App to sit in the middle and play monkey in the middle. It helps that the third-party fulfillment center also maps SKUs totally different from Shopify, and has no connection to Amazon items either. So we MAP things. And it all works!

So I am in awe of 2020! And how we solve modern e-commerce problems with frigging emails, because hey! Amazon and Shopify are so well-oiled together, like bros!

I am thinking Shopify has done all they can to ease the pain of this sales channel, but at the end of the day, there is zero-chance Amazon is going to let it function friction free, so they ensure they do things just one stroke off, one stroke different, boom. You're in the pain zone!

Good luck to you! I felt your pain! I solved it with code, and you likely can too!

 

Custom Shopify Apps built just for you! hunkybill@gmail.com http://www.resistorsoftware.com
0 Likes
Highlighted
New Member
2 0 0

Sadly not.

Had to ditch the Amazon -> Shopify link and just get orders directly from Amazon API.

As need the AmazonOrderItemId to do Seller Fulfilled Prime Shipments

0 Likes