Option to change ID ?

[coldbusted]

So far this has been very easy to set up thank you! I have 1 question so far. Are we able to change ID’s for products? Right now it starts from “1”. I run a record label and was wondering if I could change the “1” to a catalog number.

Since we have so many tracks (hundreds) to add it would be helpful to have each track associated with its catalog number.

Example: current ID is 1 but would like to change it to BUSTED01.

Thanks

[amin007]

The product ID cannot be changed as it needs to be unique so a record can be identified from the database with the ID being the key. So the plugin automatically generates ID as an incremental number (this leaves no room for any mistake).

If you want to associate the code “BUSTED01” with that product you can put it in the product name like the following for example:

Test Product Name (BUSTED01)

The other option is that I can add another database field that lets you store a special product code with every product.

[coldbusted]

No problem at all. We do have the catalog number in our product name. No need for a special product code. But thanks for the offer.

[designthemedia]

I don’t want to display the “product number ID” on the paypal part because it makes confusion between ID and quantity. (it won’t happen when I’ll have an ID = 50000 but for now…)

How could I customize that?

[amin007]

How can a quantity be confused with ID when on PayPal it clearly have a label for every field? The field Quantity means the number next to it is the quantity.

As mentioned earlier in this thread… you cannot change the Product ID. If you create some fake products and delete them it will increase the ID number. When your ID number goes to a high number you can stop doing this and actually enter your real products.

[designthemedia]

the workaround can work.

but it is not me. we have to respect our customers.. if they are confused, I can help them, but I’d prefer to use a prefix for instance…

all these products in this category named CAT1 begin with CAT1-

for instance..

[tryt53]

Hi amin007,

Thanks for all the great things you have already done for us. I have another request, if it’s possible.

When you add products, each gets a unique ID and that is the order they show up in when you go to manage products. Usaually I find these items by their name, which can be harder to find because they are no longer in alpahbetical order, but instead, in unipue id order. Many times I have to go and update the inventory on many products and it would be extremely helpful if there was some kind of re-organzing of the unique ids so they could show up in Alphabetical Order.

If that would mess up the database, if there was the ability to sort the products by other fields in the display (such as name) that would work just as well. Thank you for your consideration of this, if possible.

Regards,

Tim

[amin007]

I can add in a button that sorts the “Manage Products” menu by product name rather than ID.

Update: You can now sort by Product ID, Name, Price in the manage products menu.

[Author]

Posts