Home Page link  

Simple way to enter UPC's for Matrix Item

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Simple way to enter UPC's for Matrix Item Kris 04-14-2006
Posted by Kris on April 14, 2006, 2:36 am
Please log in for more thread options
 A majority of our items are Matrix type (we sell shoes and apparel). We
store our UPC's as Aliases. To do this we have to open every individual
matrix component, select the Alias tab, scan the UPC then save - it is a
tedious process. Is there any way to open the matrix components as a group
and just scan the UPC for one size into a column, hit the down arrow, scan
the UPC for next size, and so on - similar to what we used to do in Quicksell?
--
Kris

Posted by Rob on April 14, 2006, 11:17 am
Please log in for more thread options
 The easiest way would probably be to export a list of you Matrix Items to
Excel and scan your UPC codes for each line. Then import the Aliases using
the QSImport utility.

Rob

>A majority of our items are Matrix type (we sell shoes and apparel). We
> store our UPC's as Aliases. To do this we have to open every individual
> matrix component, select the Alias tab, scan the UPC then save - it is a
> tedious process. Is there any way to open the matrix components as a
> group
> and just scan the UPC for one size into a column, hit the down arrow, scan
> the UPC for next size, and so on - similar to what we used to do in
> Quicksell?
> --
> Kris



Posted by Greg [DRS] on April 15, 2006, 6:09 pm
Please log in for more thread options
Kris,

You can do this in Power Ops if you have installed Matrix Master.
Press Ctrl-M to view the matrix class codes, then double-click on the matrix
you want to edit.
Select Edit Matrix, Edit component items, enable Lock ILC, then scroll to
the right until you reach the UPC column.
Scan in a UPC, down arrow to next item in the matrix, scan in a UPC, down
arrow to next item, etc.
You can batch update any of the other attributes this way too (SRNs,
restocking levels, prices/costs, sub-descriptions).

Greg
Digital Retail Solutions
www.digitalretailer.com/RMSaddins

>A majority of our items are Matrix type (we sell shoes and apparel). We
> store our UPC's as Aliases. To do this we have to open every individual
> matrix component, select the Alias tab, scan the UPC then save - it is a
> tedious process. Is there any way to open the matrix components as a
> group
> and just scan the UPC for one size into a column, hit the down arrow, scan
> the UPC for next size, and so on - similar to what we used to do in
> Quicksell?
> --
> Kris



Posted by Kris on April 17, 2006, 11:26 am
Please log in for more thread options
Greg,

Thanks, I was hoping that was the case. I just upgraded to RMS from
Quicksell and I have purchased Matrix Master, we just haven't started running
it yet.
--
Kris


"Greg [DRS]" wrote:

> Kris,
>
> You can do this in Power Ops if you have installed Matrix Master.
> Press Ctrl-M to view the matrix class codes, then double-click on the matrix
> you want to edit.
> Select Edit Matrix, Edit component items, enable Lock ILC, then scroll to
> the right until you reach the UPC column.
> Scan in a UPC, down arrow to next item in the matrix, scan in a UPC, down
> arrow to next item, etc.
> You can batch update any of the other attributes this way too (SRNs,
> restocking levels, prices/costs, sub-descriptions).
>
> Greg
> Digital Retail Solutions
> www.digitalretailer.com/RMSaddins
>
> >A majority of our items are Matrix type (we sell shoes and apparel). We
> > store our UPC's as Aliases. To do this we have to open every individual
> > matrix component, select the Alias tab, scan the UPC then save - it is a
> > tedious process. Is there any way to open the matrix components as a
> > group
> > and just scan the UPC for one size into a column, hit the down arrow, scan
> > the UPC for next size, and so on - similar to what we used to do in
> > Quicksell?
> > --
> > Kris
>
>
>

Posted by Greg [DRS] on April 18, 2006, 12:59 am
Please log in for more thread options
Watch "How to become a Matrix Master in 10 minutes" at:
http://www.digitalretailer.com/POp-demo.htm

Greg
Digital Retail Solutions
www.digitalretailer.com/RMSaddins

> Greg,
>
> Thanks, I was hoping that was the case. I just upgraded to RMS from
> Quicksell and I have purchased Matrix Master, we just haven't started
> running
> it yet.
> --
> Kris
>
>
> "Greg [DRS]" wrote:
>
>> Kris,
>>
>> You can do this in Power Ops if you have installed Matrix Master.
>> Press Ctrl-M to view the matrix class codes, then double-click on the
>> matrix
>> you want to edit.
>> Select Edit Matrix, Edit component items, enable Lock ILC, then scroll to
>> the right until you reach the UPC column.
>> Scan in a UPC, down arrow to next item in the matrix, scan in a UPC, down
>> arrow to next item, etc.
>> You can batch update any of the other attributes this way too (SRNs,
>> restocking levels, prices/costs, sub-descriptions).
>>
>> Greg
>> Digital Retail Solutions
>> www.digitalretailer.com/RMSaddins
>>
>> >A majority of our items are Matrix type (we sell shoes and apparel). We
>> > store our UPC's as Aliases. To do this we have to open every
>> > individual
>> > matrix component, select the Alias tab, scan the UPC then save - it is
>> > a
>> > tedious process. Is there any way to open the matrix components as a
>> > group
>> > and just scan the UPC for one size into a column, hit the down arrow,
>> > scan
>> > the UPC for next size, and so on - similar to what we used to do in
>> > Quicksell?
>> > --
>> > Kris
>>
>>
>>




Similar ThreadsPosted
Can't enter Item Lookup Code August 1, 2008, 11:49 am
Enter the same item description for similar items April 8, 2007, 7:12 pm
SQL to enter Item.SupplierID for all child items October 22, 2007, 2:48 pm
POS - Enter quantity manually after entering your item lookup code May 13, 2008, 3:21 pm
Item Wizard for Matrix Item, 2.0, Attributes Problem, Fix w/SQL co April 5, 2007, 2:02 am
changing a standard item to a matrix item September 19, 2006, 4:01 pm
Matrix Item June 14, 2006, 10:32 pm
matrix item in rms 2.0 May 2, 2007, 12:12 pm
Matrix Item Changes June 1, 2007, 6:03 pm
Matrix Item October 28, 2007, 5:09 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap