Demos

Download AgoraCart

User Manuals & Wiki

Gold Members Forum

Go Gold Now!

Gold Version Memberships

AgoraCart.com

• About
• Features
• Download
• Payment Gateways
• Send a Donation
• Founders Club
• BLOG: News & Updates

Showcases & Demos

• AgoraCart Demos
• Shop Live Stores

Downloads & Add-ons

• Gold Version Downloads
• DBwizz Database Mgr.
• AgoraCart.com Store

Help & Support

• User Manuals
• Gold Version Users Forum
• Gold Version Chat
• Tech Support
• Certified Agora Pros
• Certified Designers
• Hire a Freelancer

Gold Version Members

• Member Benefits
• Join Today!
• Gold Members Home
• Gold Version Users Forum
• Gold Version Chat Rooms
• Gold Version Downloads

For Store Owners

• Merchant Accounts
• Cool Resources
• Advertise Here
• "Powered by" Logos
• Web Hosting Search

Misc.

• Contact Us
• MEET's Talking Guide
• The Ancient Greek Agora

AgoraCart Free User Forums

This is the official FAQ and Cool Tips guide For the AgoraCart shopping Cart software
italian charms

Official Sponsors of the AgoraCart Project:

The time now is Fri Apr 19, 24 10:32 pm

View previous topic | View next topic

Page 1 of 1

Sorting items alphabetically instead of by item #

Author

Message

collegeguy2100
Newbie

Joined: 19 Dec 2003
Posts: 6

Sorting items alphabetically instead of by item #

How do I get all of the items in one category, (when only that category is displayed by the "=category" term, to appear ALPHABETICALLY instead of by item number?

I run into this problem as I would like ALL of my items to show up alphabetically. Then when I add more items to my database as I get them in, because of item number even though it may begin with an "A" it will show up after the "Z"'s because of item number.

Please help!

Thanks

Fri Dec 26, 03 1:08 am

Mister Ed
E-commerce Engineer

Joined: 05 Nov 2003
Posts: 311
Location: If I told you, I'd have to kick yer cat! If I must: Out standing in my field of course!

for advanced database manipuation like this:

export to pipe delemeted with database manager

download data file from server (in data directory of your store)

open with a spread sheet
sort but columns alpha onthe column you with to sort by

save as pipe delimited again

upload to data directory of store

import back into store using the databse manager

double check.

Also make sure you have a back up copy of the data.file before importing the new data back into your store.

ME

_________________
Vote Mister Ed for Prez 2012, for a REAL change.

Need Low Cost Startup Option? Try NiftyPay's Pay to Play
http://www.NiftyPay.com

Sat Dec 27, 03 4:27 pm

clov78
Newbie - Two Blades

Joined: 10 Mar 2004
Posts: 31

Quote:
sort but columns alpha onthe column you with to sort by

What's THAT supposed to mean?

I've jumped on this thread because I'm trying to do the same thing.

I've tried this suggested database manipulation thing, but with little success. First, I've tried it with a csv file, because if I exported a PIPE format, excel wouldn't split it into columns - it just printed the whole record in one long row with the bar splitting the fields.

When I tried exporting a csv file, sorting it, and importing it, the data still showed up sorted by the product ID.

Am I doing something wrong?

Fri Apr 16, 04 1:35 pm

milehightrader
Guest

Quote:
What's THAT supposed to mean?

Just a little typo there. We all make them at times when we are in a hurry. What he meant was do an alpha (alphabetical) sort on the file.

Fri Apr 16, 04 4:21 pm

The time now is Fri Apr 19, 24 10:32 pm | All times are GMT - 7 Hours

Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

AgoraCart Free User Forums

This is the official FAQ and Cool Tips guide For the AgoraCart shopping Cart software #forumbbot {display:none;}italian charms

Quote:

Quote:

This is the official FAQ and Cool Tips guide For the AgoraCart shopping Cart software
italian charms