Updating Stock Levels Via Csv Upload?

Hi guys

I've got a drop shipping website with no live stock management system. Client receives a CSV every 2 days with current stock levels. Is there any way of just uploading this file to update the stock levels accordingly? He currently goes through and changes everything manually which is rather time consuming

Thanks

Hello
One of the solutions is to automatically upload csv files to the server and run a cron task that will parse the file and set the inventory
Another solution is a simple script run from cron which will download a csv file from a specific location, parse it and update the inventory.
Best regards
Robert

Hello! Do you have prices in XLS or XML formats or only CSV?

We have a solution as you requested.

XLS prices can be downloaded from URL, updates can be scheduled.

Advanced import allows to run import by cron task. But additional customization is required to download new file before each import

I'm just trying to do it via uploading the .CSV manually via the import > products (deprecated).

I can get it to change the stock level for simple products but won't change the stock level for variations.

The fields I'm using are Product Code, Language, Quantity

Any idea why the variations stock levels won't change?

What it's doing instead of updating the stock on the variations - its adding new simple products instead.

Try to add Product type column with the V value

Hi, I tried adding the Product Type column with V but it still just creates new products instead of updating the stock on the existing ones.

Here's an example of my spreadsheet - [url=https://postimg.cc/560TxpRS]spreadsheet.jpg[/url]

Hi, I tried adding the Product Type column with V but it still just creates new products instead of updating the stock on the existing ones.

Here's an example of my spreadsheet - spreadsheet.jpg

Try to export and import one product in your store. Possibly another additional fields are required to import variations

How do i export one product?

When I click "Select" to choose range (or products) to export - it takes me to the product list but there is no way to select and export. How do I export one product?

[attachment=13799:select_product_export.png]

select_product_export.png

Thanks.

And figured out the rest of it as well. Selecting Product Combinations at the top of the export screen gave me the missing fields I needed.

Thank you for keeping us updated

How do you get stock level for each variation?

Hi Skivan

You need to click the Product Combinations tab first to see the additional fields for importing/exporting variations.

[url=https://postimg.cc/NK0359Dn]Capture1.jpg[/url]

You will then see "amount" - thats the stock level for each variation

[url=https://postimg.cc/xNf25sGf]Capture.jpg[/url]

Here's an example of the sheet I use for updating stock level of products with variations/

[url=https://postimg.cc/MvLCfZLK]Capture3.jpg[/url]

Hope that helps

Hi Skivan

You need to click the Product Combinations tab first to see the additional fields for importing/exporting variations.

Capture1.jpg

You will then see "amount" - thats the stock level for each variation

Capture.jpg

Here's an example of the sheet I use for updating stock level of products with variations/

Capture3.jpg

Hope that helps

thanks