Home » Forums » Ubercart » Support
3 replies [Last post]
Sat, 09/05/2009 - 16:31
paulgrimshaw
paulgrimshaw's picture
Offline
Joined: 05/19/2008
Juice: 91
Was this information Helpful?

Hi,

Is there any way to get a unique internal code for every product (inc. the attributes)?

I have a specific use case for this and its causing me trouble. I am planning on using ubercart for my bricks & mortar store. Not all items have barcodes, not all have stock references. This means that unless I look it up manually each time, I won't know what the item is. I thought I could use a two line pricing gun (price + ref) to make it easy by pricing the product with a matching ubercart identifier, but I can't think how to do this.

If I use NID then I have trouble with the attributes and I have a barcode field but can't use that for attributes. If I use the SKU then its meaningless on other pages like reports and of course, its not automatically filled. It has to be a number for the pricing gun and of course I need to be able to somehow search by it.

I would love some suggestions if you have any.

Thanks,
Paul.

Top
Sat, 09/05/2009 - 21:22
#1 View page
Ryan
Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15438
Re: Unique _Internal_ PID?

Using SKU Adjustments doesn't work in your situation? You do have to manually assign a unique SKU per attribute combination, but it sounds like that would work.

Top
Sun, 09/06/2009 - 03:45
#2 View page
paulgrimshaw
paulgrimshaw's picture
Offline
Joined: 05/19/2008
Juice: 91
Hey Ryan, I think this is

Hey Ryan,

I think this is what I am going to have to do. Its not perfect though - When you look at the reports, say to find out what stock to order it will be meaningless for reordering. I am thinking maybe I could get someone to mod the report to show another CCK (e.g. "Supplier Ref") - is that technically possible? (at least for the main products, i'd still have to look up the attribute items).

I would still have to manually enter an SKU which would be a pain, especially with no validation done to check its unique but could maybe cope temporarily by keeping track somehow (notepad and pen!).

In the back of my mind I just thought I could somehow use a selector process, e.g. I enter the nid in a "quick add" search box and it finds a one off item it adds it, if there are attributes, it gives me a list to select. With a bit of ajax and views, this could work quite well. I'll have a ponder.

Thanks for your help,

Paul.

Top
Sun, 09/06/2009 - 06:33
#3 View page
glennnz
glennnz's picture
Offline
Joined: 01/20/2009
Juice: 451
Paul Have a look at the Auto

Paul

Have a look at the Auto SKU module.

Glenn

Top