Post Reply 2 posts Page 1 of 1
Getting Quantities from Import
  • jwol
    New User
    New User
    Posts: 23
    Joined: Sat Dec 31, 2011 11:25 am

    Getting Quantities from Import

    by jwol » Mon Jul 09, 2012 9:33 am

    We just imported a 2,000 item REDI file into inventory for a new store. Everything looked good except all of the quantites are zero rather than our on-hand count that was in the file.
    Can you please tell us how to get the quantities imported and avoid having to enter each manually?
    Thanks in advance.
  • User avatar
    RetailEdge Moderator
    Site Admin
    Site Admin
    Posts: 1290
    Joined: Mon Jan 23, 2006 4:02 pm
    Location: Rutland, VT
    Contact:

    Re: Getting Quantities from Import

    by RetailEdge Moderator » Wed Jul 11, 2012 9:27 am

    That is correct. REDI inventory imports are really designed to import new items or make changes to existing items. If you want quantities, you should simply take your existing REDI file and make a CSV file from it with two columns, SKU and Quantity. Then import this file into the PICs file (Inventory PICS menu item).

    You will then be able to either overwrite inventory quantities directly or you can add these to a Purchase Order or Receiving, depending on how you want to ultimately record these inventory quantity changes.
    jwol wrote:We just imported a 2,000 item REDI file into inventory for a new store. Everything looked good except all of the quantites are zero rather than our on-hand count that was in the file.
    Can you please tell us how to get the quantities imported and avoid having to enter each manually?
    Thanks in advance.
Post Reply 2 posts Page 1 of 1

Who is online

Users browsing this forum: No registered users and 32 guests