[SeanDigitalSave]

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

[soft-solid]

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

[RetailFactory]

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. 

[eComLabs]

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

[SeanDigitalSave]

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?

[SeanDigitalSave]

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

[eComLabs]

Try to add Product type column with the V value

[SeanDigitalSave]

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 - 

[eComLabs]

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 - 

 

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

[SeanDigitalSave]

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?

[The Tool]

[SeanDigitalSave]

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.

[eComLabs]

Thank you for keeping us updated

[Skivan]

How do you get stock level for each variation?  

[SeanDigitalSave]

Hi Skivan

 

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

 

 

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

 

 

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

 

 

Hope that helps

[johnbol1]

Hi Skivan

 

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

 

 

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

 

 

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

 

 

Hope that helps

thanks