Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
 
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

Find us on Facebook Follow us on Twitter View our YouTube channel
Search our site
Forum Search
Google Site Search
 All Forums
 Technical
 ASP (Windows server) versions
 Mass Edit pID Field?
Author « Topic »  

cooper
Ecommerce Template Guru

USA
2807 Posts

Pre-sales questions only
(More Details...)

Posted - 08/21/2018 :  04:46:51  
Love the mass edit options in the product admin area.

Is there a way to mass edit the pID field? I uploaded product ID's with the size and color options so I can quickly add the correct product option, but now I don't want the pID to end with "S M L XL Blue Red Green Yellow". Is there a quick way to do a mass edit instead of clicking into each product?

Cooper

Andy
ECT Moderator

95440 Posts

Posted - 08/21/2018 :  04:57:24  
Hi Bill

You could add this to includes.asp so the pID shows in the product admin quick entry feature

customquickupdate="pId:ID Field"

It should be fine but if you see any strange behavior just remove the line

Andy

Please feel free to review / rate our software

cooper
Ecommerce Template Guru

USA
2807 Posts

Pre-sales questions only
(More Details...)

Posted - 08/21/2018 :  05:30:36  
Thanks for the quick reply, Andy.

No luck. Got an error message on the product admin page.

I'll stick with with click, edit and submit method.

Cooper

dbdave
ECT Moderator

USA
10507 Posts

Posted - 08/21/2018 :  06:27:39  
It should work.
Here is the post from Vince where it was introduced https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=109004
You will need version v6.8.2 or newer.

quote:
It is now possible to add your own columns to the Products Quick Update menu by using the parameter...
customquickupdate="CustomDBColumn,CustomDBColumn2" ' ASP
$customquickupdate="CustomDBColumn,CustomDBColumn2"; // PHP
You can specify more than one column by using a comma to separate. The Quick Update menu will display the database column name, unless also specified separated by a colon. For instance...
"CustomDBColumn:DB Column 1,CustomDBColumn2:DB Column 2"
Finally, the datatype of the column will be assumed to be text, unless also specified separated by a colon as NUM for numeric or CHECK for checkbox / (Yes/No). For example...
"CustomDBColumn:DB Column 1:NUM,CustomDBColumn2:DB Column 2:CHECK"


I think Andy just had the "D" there lowercase and I expect it's case sensitive being a database column.

try customquickupdate="pID:ID Field"
You should be able to name ID Field (in red) anything you like there.
EDIT - I just tested it on my dev site - it works perfectly, but so did the version Andy suggested, so for ASP it does not seem to be case sensitive, so perhaps you have an older version there.

Edited by - dbdave on 08/21/2018 06:35:20
  « Topic »  
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2022 ecommercetemplates.com
This page was generated in 0.02 seconds. Snitz Forums 2000