Ahh, this would definitely be good to have.   +1 to making this available in the REST API. ... View more

+1 as well to have this included in the Variant data instead of having to make an additional call to the Metafields endpoint. ... View more

Hi Rooney,   As the others have mentioned, it would depend on how the inventory data from the other site can be retrieved.   For example, if the other website can provide a public link where the latest inventory data can be downloaded from in CSV or Excel format, apps such as our EZ Inventory app can help with this.   Other common methods of pulling the inventory data from another source outside of an API is via FTP or SFTP/SSH, which our app and other inventory apps support as well. ... View more

 Hey Kristo,   I found this link from Shopify's docs that I think is what you're looking for: https://help.shopify.com/en/manual/locations/changing-quantities/exporting-or-importing-inventory   However, it looks like they have very specific requirements with how the CSV should be formatted.   If you're open to using an app, our EZ Inventory app could simplify this process for you as all it needs is the product identifier field and the quantity field from the CSV/Excel file.   For example, you can create a data feed settings in EZ Inventory where you specify the SKU and quantity column from the CSV/Excel inventory file.  Then all you have to do is upload the file and click a button to start the bulk update in your Shopify store.  You can then reuse these settings for future updates.   If your supplier's website's download link is publicly accessible, you could even potentially automate this from our app by pasting the download link URL in the data feed settings in our app and schedule an automated run.  Please note that the link must be the direct download link and doesn't require logging in via a form (our app does support "Basic Auth" for authentication (where you normally get a pop-up to enter a username and password when accessing a site), just not form-based authentication).   Please feel free to reach out to me directly at jonathan@highviewapps.com if you have any questions. ... View more

Hi Lili,   Our app EZ Exporter can export the tracking numbers for you as well into a CSV file and you can customize the CSV output within our app so you can include just the data that you need.    It can also export Fulfillment Events (https://help.shopify.com/en/api/reference/shipping-and-fulfillment/fulfillmentevent) as part of the order export (we do the join on our side based on the order_id) so you can pull additional information such as the delivery date and the shipping carrier's message.   Please feel free to email me at jonathan@highviewapps.com if you have any questions.     ... View more

Hey Nicole, I wasn't able to come up with a workaround unfortunately. :( Our app has a grouping and aggregation feature where the user can basically select which fields to group by and specify the aggreagation functions to use.  But for something more complex like this where you're now dealing with multiple subsets and joining them together, I just couldn't come up with a UI to provide to our users that will be user-friendly.  This is one of those scenarios that an SQL query seems to be the best approach. ... View more

No problem Ron. It certainly makes it more complicated as it's an additional step.  It used to be possible to update the variant inventory quantity directly via the Variant API (now this field is read-only). I believe they had to make this change when the Multi-Location Inventory feature was introduced as the database schema changed where the inventory quantity is now stored in a separate table (InventoryLevel) and must now always include a Location even if the store doesn't use the multi-location feature. It does seem like there could've just been a direct relationship between InventoryLevel and the Variant resource instead of creating a separate InventoryItem resource, but I'm sure they had good reasons for designing it this way. ... View more

Hey Ron, The Inventory Item ID is used in the new Inventory APIs.  It's a separate resource from the Variant but there's a 1-1 relationship between the Variant and InventoryItem resources. For example, if you need to update the InventoryLevel of a Variant, you'll need the Inventory Item ID as the InventoryLevel is attached to the InventoryItem.  So you'll basically have to pull the inventory item ID via the Variant API (i.e. variant.inventory_item_id) first, and then make a call to the InventoryLevel API using that inventory_item_id and the location_id (new requirement when the Inventory APIs were introduced). More info here: https://help.shopify.com/en/api/reference/inventory/inventoryitem https://help.shopify.com/en/api/reference/inventory/inventorylevel Hope that helps! ... View more

Hey p0tt3r, I'm probably a bit late but in case you haven't found a solution yet, our app EZ Inventory might be able to help with tihs. Our app can automatically sync the inventory quantity from the data feed on the FTP server as frequent as every 1 hour.  Our app supports creating low stock alerts as well. ... View more

Hey Nicole, I contacted Shopify about this and basically they don't recommend compariing the data from the exported CSV to the one generated in the "Analytics" section of the Shopify Admin as the reports in the Analytics dashboard pull the data in different ways. For example, the Refunds in the Analytics dashboard is based off the date the refund occurred and not the date of when the order was created.  So it's like doing a separate query for the Refunds and grouping/aggregating that data by the Refund Date and then joining that back to the rest of the aggregated Order data. They do have an Analytics API but it's only available to Shopify Plus stores and it only works with the Embedded App SDK/Javascript so you can't run it in the backend for automated scheduled runs. I did ask them whether there's a plan to make the API available in the REST Admin API and unfortunately the answer is no when I asked them back in October. :( ... View more

Hey Nola, In case the developer of the private app is not able to resolve the issue and you're open to trying out a public app, we have an app EZ Inventory that has multi-location support and can sync your stock level as frequent as every 1 hour. Please feel free to contact me directly at jonathan@highviewapps.com if you have any specific questions about our app. ... View more

Hey Nicole, I've asked Shopify about this as well a couple months ago and was told that there are no plans to make this available via the REST Admin API. :( ... View more

Hey David, Our app EZ Inventory may be able to help as well and supports syncing from multiple supplier feeds as frequent as every 1 hour. We have a 15-Day free trial so you can try it out first to make sure it can meet your requirements. Best, Jonathan ... View more

Weird, the test store that we have is for Shopify Partners/Affiliates.  I believe this is basically equivalent to the "Advanced Shopify" plan. ... View more

Hey Don, Our app, EZ Exporter, can automate this process for you. You can create multiple "Export Profiles" with our app and have a custom CSV set up for each dropshipper and schedule them to get sent out via email automatically. We have a Dropbox integration as well so you can technically just schedule an automated CSV export directly to Dropbox, say every 15 minutes, and that file just gets overwritten with the latest data.  In Dropbox, you can then create a "shared link" of that file that your dropshippers can access.  This is probably a simpler approach. Please feel free to reach out to me directly at jonathan@highviewapps.com if you have any questions about our app. ... View more

Hey Jean-Marc, As far as I know, this is not possible with Shopify.  To stock inventory of a variant in multiple locations, the inventory has to be managed by Shopify for that variant. I asked a similar question a few weeks back in this thread and a Shopify employee confirmed this is not possible: https://ecommerce.shopify.com/c/api-announcements/t/updated-deadline-aug-1st-deprecation-important-changes-to-productvariant-refund-and-fulfillment-apis-513771 A variant can not be stocked at a fulfillment service ("legacy" location), and a standard location simultaneously. That is the only restriction on it, which is on a per variant level.   ... View more

Hmm...that is odd that they would remove that. I just did a product export on one of our test stores (Partner store) and the "Variant Inventory Qty" field is still there for me. This does seem like a bug and maybe it's fixed now? On the API side, even with the new multi-location feature and the new Inventory endpoints, the `inventory_quantity` field on the Variant API is still available but is read-only. It's basically the total inventory quantity across all locations. ... View more

Hi Christopeher, We have an app, EZ Exporter, that might be able to help with this.  However, the data won't be real time as the highest export frequency we support is every 15 minutes. If having a potential delay of 15 minutes is possible, a possible set up is something like this: 1. In EZ Exporter, connect a Dropbox account. 2. In EZ Exporter, schedule an automated CSV export of your inventory every 15 minutes containing just the data that you need to Dropbox and call the file something like inventory.csv (thils file will get overwritten with the latest data during each automated run). 3. In Dropbox, create a "shared link" of that file and send that link to your distributors so they can simply go to that link and view your latest exported inventory data at any time. If you have any questions, please feel free to reach out to me directly at jonathan@highviewapps.com. ... View more

Hi King, Our app, EZ Exporter, can bulk export the tracking numbers for you as well.  You can export them both on the order level and the line item level (in case there are multiple fulfillments, you can see which tracking numbers are associated with each line item). Please feel free to reach out if you have any questions!     ... View more

+1 Would love to be able to access this via an API endpoint as well so we could update our own internal dashboards automatically instead of doing manual exports and imports of the CSV. ... View more

Just bookmarked this, thank you! +1 for email notifications and/or RSS feed ... View more

Hi there, We have a custom CSV exporter app, EZ Exporter, that can display this data for you: https://apps.shopify.com/ez-exporter In addition to the regular lineitem/variant fields included in the Shopify order export, our app can also pull additional variant attributes such as the variant optiions which I believe is what you're looking for. Please feel free to reach out if you have any questions.   ... View more

Hi there, Our app EZ Exporter can help with this as well. We have advanced custom filtering support so you can specify something like this in the order export: Customer Tags contains google We have a grouping and aggregation feature also. So in additional to specifying the filters, you can also group by a field and aggregate the values of certain fields within that group. Feel free to contact us if you have any questions. ... View more

Hey Gabriel, For an automated CSV export of your inventory, our app EZ Exporter can help with this.  You can schedule an automated export as frequent as every 15 minutes with our app. You can create multiple "export profiles" with our app so you can have different configurations and schedules for each of your suppliers.  You can set filters for each one as well so you can segment your product data for each dropshipper. Please feel free to reach out if you have any questions.   ... View more

Hey Mark, Our app EZ Exporter can help with this as well.  We have a Dropbox integration so you can automatically schedule an export directly into a Dropbox folder.  From Dropbox, you can then create a shared link/URL for that file. If the order export contains personal information, though, you probably don't want that shared link to be public.  Dropbox has an option to password-protect shared links in the Professional and Business plans. Our app also allows you to customize the CSV so you can generate a CSV with just the fields that you need. Please feel free to reach out if you have any questions! ... View more

Hi Mo, For the Order export part, our app EZ Exporter might be able to help with this.  It's designed for creating custom CSV/text exports (we support different types of delimiters, quoting options, and line terminators). It supports exporting to FTP, FTP with TLS, and SFTP (in addition to email, Dropbox, and Google Drive). For the filename, we have variables that you can use to capture the timestamp. Using the vars {{ date }}{{ time }} in the filename for example would produce the YYYYMMDDHHMMSS format that you need (e.g. 20180907213153). We also have a feature called "Calculated Fields" that would allow you to use conditonal statements like this: "ABCDEF" if {{ shipping_address.country_code }} == "UK" else {{ shipping_address.country_code }} For the daily inventory sync, we do have another app for auto-updating inventory quantity with multi-location inventory support: EZ Inventory.  However, it can only sync the inventory quantity at the moment so I'm not sure if that's good enough for your needs.  It supports FTP/SFTP/Web feeds, hourly and daily sync, and different types of inventory updates (set/overwrite, increase, or decrease the stock level). It has a pretty flexible data filter option also so you can set conditions in the app to filter just the products you want to update from the feed. Please feel free to reach out if you have any questions! ... View more

Hi Chris, Our app, EZ Exporter, will be able to export these Line Item Properties for you. Our app is designed for generating custom CSV files and it can place each line item property in separate colunms in the CSV. If you have any questions, please don't hesitate to reach out! ... View more

Hi Andre, For the reporting part, our app EZ Exporter can help with this.  The custom fields at checkout are normally captured in Cart Attributes (also known as "Note Attributes") or Line Item Properties. Our app supports exporiting of both Cart Attirubtes and Line Item Properties.  Each custom cart attribute or line item property can be placed in a separate column in the CSV generated by our app. Please feel free to reach out if you have any questions on this. ... View more

Hey Joe, Our app, EZ Exporter, can help with this as well.  We support grouping and aggregating of data so you can, for example, group by month then by the line item, and then do a sum of the refunded quantity and amount.  It's quite flexible so you can really customize your report. You can also schedule the reports to run automatically and have it delivered to you or your team via email or to a Google Drive or Dropbox folder. Please feel free to reach out if you have any questions. ... View more

Hi Ben, Jonathan from Highview Apps here :) One possible thing you can do is store the data in Customer Metafields.  You can use a free app like ShopifyFD (Chrome extension) to add custom Metafields to your customer data: http://shopifyfd.com/ Then, in EZ Exporter, in the Data Settings for that order report, scroll down a little and go to the "Metafields" section where you can then enter the Customer Metafield "key" (i.e. the fieldname) that you specified in ShopifyFD. When you run the report, EZ Exporter will search your Customer Metafields data and pull the value that matches that "key", so you can include those values automatically as part of your order export. Hope that helps! Let me know in case you have any questions! ... View more