is there an app what can auto update my stock qtys from my suppliers using excel

is there an app what can auto update my stock qtys from my suppliers using excel

fuzzy81
Visitor
1 0 1

Hello,

Hope you guys can help and point me n the right direction

 

i currently have products listed on my website but have trouble keeping up with the stock qty's , is there a way where i can put my suppliers stock list which is in excel format (which has a running update) to update my qtys?

thank you 

Replies 4 (4)

Ellie-BOGOS
Pathfinder
77 10 13

Hi @fuzzy81 😁

 

This is Ellie from BOGOS (formerly Free Gifts by Secomapp), the #1 Promotion App on Shopify.

 

Here are some apps I recommend you to use:

  • syncX: Stock Sync: Import/export data through compatibility with formats like CSV, XML, Google Sheets, and APIs. Automate syncing inventory and product updates with suppliers
  • Hextom: Bulk Product Edit: Schedule bulk edit, CSV import export for sales, inventory sync, product launch

 

Please try them on your end, and let me know if they are what you need! 💖

 

If my answer is helpful, I appreciate it if you can give me a Like or accept it as Solution!

 

Ellie

BOGOS (formerly Free Gifts by Secomapp)

If it is helpful, let me know by giving a Like or Accept solution.
Use BOGOS.io Free gift to create special promotions: BOGO, gift with purchase, product bundles, quantity breaks on your store!
Have a nice day ^_^

ProfitLabs
Shopify Partner
145 6 19

Hi @fuzzy81,

 

You can update the stock quantity directly from the Shopify admin. To do this, go to 'Products', then open 'Inventory'. There, you will find an option for 'Import and Export' at the top right, where you can manage it. Thank you.

Abhinav | Shopify Partner
- If helpful, please Like and Accept Solution.
- Creator of Sync Inventory - GoGo - Sync Inventory Across Multiple or Single Shopify Store .
- Creator of Profit Bundles - Sell Omni Sales Channel Bundles that you can fulfill yourself or even by a 3PL or Dropshipper.

Jonathan-HA
Shopify Partner
325 25 100

Hey @fuzzy81 ,

 

If you're open to using an app, our EZ Inventory app can update the available quantity in Shopify by uploading an Excel file.

 

The Excel file just needs a column for the product/variant identifier (such as the Barcode or SKU) and a quantity column which you would then map in the app (it can have other columns, but those are the only 2 required).

 

You can manually upload the Excel file in the app to do a bulk update.  If your supplier provides a way to pull the stock list in an automated way (such as from an FTP/SFTP server or if it can be downloaded from a website), then you could potentially automate this process as well.

 

Feel free to contact us if you have any questions.

Co-Founder / Developer at Highview Apps
Our Shopify Apps: EZ Exporter | EZ Inventory | EZ Importer | EZ Notify | EZ Fulfill

Yasin_SyncX
Shopify Partner
11 0 2

Hi @fuzzy81 ,

 

You can use the Import function on the Product page. However, you will need to convert the Excel file to CSV. 

 

If you are interested, you can use syncX: Stock Sync to directly sync the products from your supplier to the stock list of your Shopify store by mapping the fields. You must map the identifier SKU field and the quantity field from the stock list. And Stock Sync will update the stock. You can do this manually by uploading the file or automate process if the file is downloadable from their website or server. 

 

Do contact us if you need further assistance.

Senior Product Manager @ SyncX
Our Shopify Apps: syncX: Stock Sync | syncX: FulfillSync | syncX: Exportible