Hi, I am trying to figure out what I need to do (or how) to update stock level using a script or something. Is there anyway stock level can be updated without having to go thru every single product? I have few products out of stock and I need to update them with the current stock level from the current inventory file.
 
thanks,

by the way, am using ver 3.5

I think this may make things quicker.
 
Go Products > Products & Categories
 
Choose a category and then tick of the check box (to the left of product name) for all products you want to update.
 
Then click on the edit selected link at the bottom.
 
Then choose the field you want to update e.g "quanitity in stock" , not forgetting of course to choose product name so you know which product is which.
 
Then just update the fields and click Update"

thanks freezer,
 
I do realize that, and that's what am having to do now. My point is manual copy/paste of quantity gets old after a while and source for screw up. Or, I have tried to delete all products and import an updated inventory file... not a clean solution...
 
Am thinking I should be able to click some place and upload the current inventory, csv. or have it (viart shop) look for a file at a location.... the file is continuously/daily maintained.
 
If I import csv it will be considered as "new" product, which I don't want. Am thinking during import, the tool should ask whether this is an update or new product. And If "update" then look for matching manu. part number and update the table content. Is there anything that that.
 
thanks,

okay I went thru the documentation and found the following in the import/export section:
 
" 5. Click the 'Continue' button. The system will compare the existing set of products with the data in the CSV file and generate a resulting table where every product is assigned one of the following statuses:
 
* New means that this product doesn't exist in the system database and you can easily import it.
* Error means that some data doesn't match with the database columns and you have to correct it.
* Exists means that the same product already exists in the system database. "
 
Okay now I know that the system does what I expect it to do it's just that there is error someplace.
 
I'll submit a ticket for help.
 
thanks

Oh sorry I thought you only had a "few" products to update.
 
We actually update by updating the actual va_items table direct using a microsoft access update query using odbc.
 
This is rather more complex though and in addition you would need to be hosting the database on your own server.
 
Let me know how you get on with Import export facility

I have started using mysql GUI to access the data from the back end.
 
But I still needed to understand the issue... anyway it turns out admin_import.php needed to be upgraded/replaced.
 
works great now.
 
thanks,

I'm interested in this feature. Now I've got the excel/csv for our ERP, but need to manually compare to the old stock and make the changes by hand.
 
Could be really good to have:
- Code or Manufacturer Code (the same codes used for ERP and Viart)
- and Stock level
in a simple cvs file, and do the update by Viart. I think, now the update only appears in the import if the Product ID is palced in the cvs. But it is not needed if the Code/Manufacturer Code is individual.
 
Costom codeing or new feature?

yeah, I approached viart about that and definitely custom coding.... if you want something other than product ID for a Key.
 
The way it is now you have to assign a product ID for each product (say 1, 2, 3 ... 30,000), so you as a business owner have to keep track of product ID you assigned for each product as you manage your inventory... if you have a small inventory, it's non-issue. But if you have grand vision for your business ... this can be a drag.
I don't know why manu. ID or SKU is not used to set the "key parameter" for a product.

I've submit an develope request:
------------------------------------------------------
In product import (update) use CODE or MANUFACTURER CODE as a key for assign rows (Or make selectable the primary key for the assignment).
 
Include Individual Price data into the Product import/export function.
 
Possibility to push multiple Individual Prices for one Product, use the Active, Min, Max, Individual Price, Options Discount (%), User Type, Discount Setting fields - to speed up the first time data inserting.
------------------------------------------------
I think this will be custom coding - altrought near all of viart users need this function.
 
Maybe the Product Specification export/import could be improoved too, but now thatrs not our main problem...
 
I'll post the coding estimation and new functions availability here...