Print Page | Close Window

batch update

Printed From: Almyta Systems
Category: Almyta Control System (ACS) and ABC Inventory
Forum Name: Inventory Control
Forum Discription: Inventory operations
URL: http://www.almyta.com/forum/forum_posts.asp?TID=15844
Printed Date: 27 May 2018 at 6:49am
Software Version: Web Wiz Forums 10 - http://www.webwizforums.com


Topic: batch update
Posted By: sovanaphum
Subject: batch update
Date Posted: 10 Dec 2017 at 6:04am
Hi,

I would like to update unit price of some products. Is it possible to load file containing a list of item ID and its new unit price and do the update in one go? Thanks.

Regards,
SP



Replies:
Posted By: WGA
Date Posted: 13 Dec 2017 at 2:59pm
There sure is, check out page the Quick Start Manual starting at page 14.
Set up the CSV file with the ItemID's as listed in ACS & price the for each, any other column can be setup up to be ignored during the import process.
You don't need to include the items that do not need updating.
This is the actual wording on page 15 for what you are trying to achieve.
"For instance, to load new prices, you need to import only two columns, Item ID and Unit Price"

You can do the same for an inventory count but its a little trickier!
I have some notes on the best way to attack it if you need them, post your email address & I will send it to you.



Posted By: Debra
Date Posted: 28 Dec 2017 at 4:14pm
Always try a single row for a test. In fact, the Data Import screen allows you to type in any values without importing a file. Map Item Id and input any existing one. Map Price and input something in like 12345.67. Import. Go to the Item Master, find the modified ID. If you see 12345.67 in the Price then your test succeeded. Change the price to what is was prior to your test.


Posted By: sochenda
Date Posted: 02 Jan 2018 at 2:35am
Could you please share me for the count to soc**@gmail.com?

Sochenda



Print Page | Close Window

Forum Software by Web Wiz Forums® version 10 - http://www.webwizforums.com
Copyright ©2001-2011 Web Wiz Ltd. - http://www.webwiz.co.uk