No export of category data?

The AbleCommerce data exchange is a useful feature for importing and updating data. The Data Exchange feature (just like the 7.0.x data port) is only supported via the forums or paid support.

*** BACKUP YOUR DATABASE BEFORE ATTEMPTING TO USE THESE TOOLS ***
Post Reply
frankenstein897
Commander (CMDR)
Commander (CMDR)
Posts: 159
Joined: Wed Feb 16, 2011 11:51 am
Location: Indiana
Contact:

No export of category data?

Post by frankenstein897 » Sat Oct 05, 2013 11:47 am

It does not seem to export the category descriptions, etc. Or am I missing a setting?
Thanks,
Chris

http://www.networkcablesonline.com
Network Cables Online, LLC
Running AbleCommerce GOLD R6

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: No export of category data?

Post by Katie » Mon Oct 07, 2013 3:04 pm

What page are you trying to export from?
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

frankenstein897
Commander (CMDR)
Commander (CMDR)
Posts: 159
Joined: Wed Feb 16, 2011 11:51 am
Location: Indiana
Contact:

Re: No export of category data?

Post by frankenstein897 » Wed Nov 06, 2013 8:18 pm

Sorry I missed this message. I am just trying to export all of my categories with the descriptions, titles, keywords, etc. I am on Gold R6 using the Data\Export...no options for just categories.
Thanks,
Chris

http://www.networkcablesonline.com
Network Cables Online, LLC
Running AbleCommerce GOLD R6

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: No export of category data?

Post by Katie » Thu Nov 07, 2013 5:12 am

Hi Chris,

Sorry, but the export of categories is not something we've added yet. You are welcome to request it using the green Feedback button. It seems like a good feature to add. The only export options we have in R6 are for Orders, Products, Product Variants, and Worldship data.

Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

frankenstein897
Commander (CMDR)
Commander (CMDR)
Posts: 159
Joined: Wed Feb 16, 2011 11:51 am
Location: Indiana
Contact:

Re: No export of category data?

Post by frankenstein897 » Thu Nov 07, 2013 7:53 am

I am thinking of checking the database to see where that is stored since I have full access to the SQL server. I am guessing most of it is in a table.
Thanks,
Chris

http://www.networkcablesonline.com
Network Cables Online, LLC
Running AbleCommerce GOLD R6

frankenstein897
Commander (CMDR)
Commander (CMDR)
Posts: 159
Joined: Wed Feb 16, 2011 11:51 am
Location: Indiana
Contact:

Re: No export of category data?

Post by frankenstein897 » Mon Nov 11, 2013 10:30 am

Got the category data out of the categories table, imagine that :-). However, it doesn't contain the URL for the category. Anyone know what table those are stored?
Thanks,
Chris

http://www.networkcablesonline.com
Network Cables Online, LLC
Running AbleCommerce GOLD R6

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: No export of category data?

Post by Katie » Mon Nov 11, 2013 11:28 am

Would it be in the AC_customURL table?
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

frankenstein897
Commander (CMDR)
Commander (CMDR)
Posts: 159
Joined: Wed Feb 16, 2011 11:51 am
Location: Indiana
Contact:

Re: No export of category data?

Post by frankenstein897 » Mon Nov 11, 2013 11:42 am

I checked that table only contains any URLs that I manually typed in the custom URL field. I am guessing the category URLs aren't stored anywhere. I am assuming they are generated via logic in the code somewhere unless a custom URL is specified then it references that table. I found an alternate way to get the URLs but not from the system (had to go to Google for it :-)).
Thanks,
Chris

http://www.networkcablesonline.com
Network Cables Online, LLC
Running AbleCommerce GOLD R6

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: No export of category data?

Post by Katie » Mon Nov 11, 2013 1:16 pm

I am guessing the category URLs aren't stored anywhere. I am assuming they are generated via logic in the code somewhere unless a custom URL is specified then it references that table.
That's correct. All catalog objects (products, categories, webpages, and links) are generated automatically using the Title field and Store URL.

Glad you found the answer.
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

msandin
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 30
Joined: Tue Jul 15, 2014 11:29 pm

Re: No export of category data?

Post by msandin » Fri Aug 15, 2014 11:51 am

Katie

Katie, this Miles Sandin. You helped me a few weeks ago when I was struggling with export/import (R8 Gold). I'm progressing in my quest but now I have another issue. Is there any way to have export/import work with tab separated values in lieu of comma separated values? Reason being, in our description field, for many parts there are commas. Thus the csv file gets messed up during processing.

Thanks so much for your help.

Miles Sandin
Bridgewater, VA

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: No export of category data?

Post by Katie » Fri Aug 15, 2014 12:27 pm

Hi Miles,

When you import products, there is a data format section (2nd page of import wizard) which allows you to choose from 4 delimiters (comma, semicolon, tab, and pipe).

Hope this works out for you,

Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

Post Reply