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
 PHP (Unix / Linux / Apache) versions
 Product admin meta desc & page title fields SORTED
Author « Topic »  

1818charlie
ECT Moderator

United Kingdom
1194 Posts

Posted - 11/25/2020 :  13:27:42  
Today I've been chatting with a client I've dealt with since 2007 & they have looked after their own product listings. Having checked over their products in the admin, they have over 8000, I've notice that many are not using the Meta Description or Page Title tag fields in the admin. The ones that do have those fields completed Google seems to like what it's seeing.

My question is would it be at all possible for those two fields to be shown via the Quick Entry, even just for the purpose of seeing which prod's have zero in those two fields, instead of going into individual products?

Steve
Egerton Village, Bolton, UK

Edited by - 1818charlie on 11/26/2020 10:37:36

dbdave
ECT Moderator

USA
10408 Posts

Posted - 11/25/2020 :  14:02:23  
Hi Steve, yes that is possible.
A new feature was added some time back to have any custom fields you might have, added to the quick entry.
I'll dig up the post from the updaters forum and post back.

David

1818charlie
ECT Moderator

United Kingdom
1194 Posts

Posted - 11/25/2020 :  14:06:28  
Hi Dave

Cheers for that!

Steve
Egerton Village, Bolton, UK

dbdave
ECT Moderator

USA
10408 Posts

Posted - 11/25/2020 :  14:16:33  
Ok, it took me a moment to find it...

https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=109004

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"


Let me know if you have trouble setting it up.
David

1818charlie
ECT Moderator

United Kingdom
1194 Posts

Posted - 11/25/2020 :  14:25:01  
Thanks for that Dave. I will keep you updated on progress

Steve
Egerton Village, Bolton, UK

dbdave
ECT Moderator

USA
10408 Posts

Posted - 11/25/2020 :  14:38:46  
You'll need the names of those columns from the database.
Hop in phpmyadmin to get those.

David

1818charlie
ECT Moderator

United Kingdom
1194 Posts

Posted - 11/25/2020 :  17:34:41  
Hi Dave

I've had a look in phpMyAdmin & nothing obvious is showing. I will revist this tomorrow evening, UK time, & spend more time on it. Thanks for your time.

***UPDATE*** Thu 26th Nov - Added the following line to the includes file & both show in the Quick Entry. $customquickupdate="pMetaDesc,pTitle"; They do show in the Quick Entry drop down as those parameters, not as Page Title, Meta Description, I can live with that.

To retrieve the two parameters that I have used, pMetaDesc,pTitle, I looked at the page source of the products admin page. If there is a better / preferred method I suppose someone could advise.

Steve
Egerton Village, Bolton, UK

Edited by - 1818charlie on 11/26/2020 06:22:40

dbdave
ECT Moderator

USA
10408 Posts

Posted - 11/26/2020 :  07:34:52  
Hi Steve, the colon there gives you a name, and the comma separates, so I think you could go with

$customquickupdate="pMetaDesc:Page Meta,pTitle:Page Title"; to get something more friendly

Thanks,
David



1818charlie
ECT Moderator

United Kingdom
1194 Posts

Posted - 11/26/2020 :  10:37:17  
Hi Dave

Works a charm, spot-on

Steve
Egerton Village, Bolton, UK
  « Topic »  
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2022 ecommercetemplates.com
This page was generated in 0.06 seconds. Snitz Forums 2000