Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Product ID

 
Reply
   X-Cart forums > X-Cart 5 > General questions (X-Cart 5)
 
Thread Tools Search this Thread
  #1  
Old 03-13-2021, 06:14 AM
 
Dawn Howard Dawn Howard is online now
 

eXpert
  
Join Date: Apr 2006
Posts: 229
 

Default Product ID

Having recently switched from Xcart 4 to Xcart 5, I'm struggling to understand the role of Product ID in Xcart 5. Note, out internal CRM is not linked to Xcart.

In 4, when I added new products, I did so by import to control the Product ID name, and match it with the SKU. Otherwise, the Product ID would be randomly generated. Matching Product ID and SKU make future product updates via import easier.

In 5, the Product ID is randomly generated again when adding a new product manually, but it doesn't seem to be a required field for import, only SKU. So I'm thinking I no longer need to worry about them matching.

Is there something I might be missing? I add new products regularly, and would like to update several of them at once in the future using import. I don't want Product ID to be an issue.

Thanks in advance!
__________________
Dawn
X-Cart Business 5.3.6.3
Mods:
Qty input - Custom Mod
Part numbers near title - Custom Mod
Membership approval before ordering - Custom Mod
Order Forms - Custom Mod
Freight on Board - Custom Mod
Catalog Order Form
Call For Price
Template: Crisp White skin
Running on Windows
Reply With Quote
  #2  
Old 03-13-2021, 09:16 AM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,197
 

Default Re: Product ID

Product ID is never random. As with any other ID for any other entity - customer, order, category, etc. The ID field is the unique identifier for the corresponding table in the database and is a sequential number. Always increments by 1 (unless the actual table is set differently which is almost never the case) from the last id.


If last product you added has an id of 10 the next one will have an id of 11. If you delete the product with an id of 10 the next one will be 12 - since there is 11.



Look at these IDs as unique IDs for internal use. You don't need to know the id or reference it unless you are using dynamic urls for storefront or trying to access the record in the backend with direct url.


Importing new or existing products (update) - no need to know or reference the id. The sku is enough to identify the product as it is unique.
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote

The following user thanks cflsystems for this useful post:
Dawn Howard (03-15-2021)
  #3  
Old 03-15-2021, 06:20 AM
 
Dawn Howard Dawn Howard is online now
 

eXpert
  
Join Date: Apr 2006
Posts: 229
 

Default Re: Product ID

Thank you, that is very helpful! Can I add new products with a CSV and choose the Product ID, like I was able to in xcart 4? What is the import field called? It was "!productid" in X4
__________________
Dawn
X-Cart Business 5.3.6.3
Mods:
Qty input - Custom Mod
Part numbers near title - Custom Mod
Membership approval before ordering - Custom Mod
Order Forms - Custom Mod
Freight on Board - Custom Mod
Catalog Order Form
Call For Price
Template: Crisp White skin
Running on Windows
Reply With Quote
  #4  
Old 03-15-2021, 06:21 AM
 
Dawn Howard Dawn Howard is online now
 

eXpert
  
Join Date: Apr 2006
Posts: 229
 

Default Re: Product ID

Also, can I export products and include the Product ID as a column?
__________________
Dawn
X-Cart Business 5.3.6.3
Mods:
Qty input - Custom Mod
Part numbers near title - Custom Mod
Membership approval before ordering - Custom Mod
Order Forms - Custom Mod
Freight on Board - Custom Mod
Catalog Order Form
Call For Price
Template: Crisp White skin
Running on Windows
Reply With Quote
  #5  
Old 03-15-2021, 06:25 AM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,197
 

Default Re: Product ID

No and no. Unless you have custom module to extend the stock behavior and process ids
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote

The following user thanks cflsystems for this useful post:
Dawn Howard (03-15-2021)
Reply
   X-Cart forums > X-Cart 5 > General questions (X-Cart 5)


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 12:38 AM.

   

 
X-Cart forums © 2001-2020