Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

How to import Tags (and other missing fields) for each product via the 'Tags' Addon? (../schemas/exim/) Rate Topic   * * * * * 1 votes

 

Posted 09 November 2011 - 09:45 PM #1

Hello,

Having spent to to long adding tags to products via the product page, i've decided it is just not a feasible task that can be expected to perform with thousands of products.

When you create a product, if you scroll down that page you can add a bunch of tags such as: grey, blue, green, red, jacket. This will then populate the Tag Cloud (add to layout via Blocks), and as words become more popular, they also become larger in size.

I've got an excellent Excel Spreadsheet that currently manages all the products, supporting filtering and concatenation of fields to simplify and ease the data input process.

The problem is, that Meta Keywords, and Search Words are available which is fine, however there is no TAGS field to import against for data to be loaded into the DB against each particular product...

I've made the following modification to assist the process of bulk importing Products but more importantly: "Product Options" and "Option Combinations" (which already uses the "product_id" field!), however am totally confused and have no idea how to get Tags (which is an Add-on) to be included in import / export!

Thanks in advance for your help! Posted Image


UPDATE THE FOLLOWING CODE IN /schemas/exim/products.php @ Approx Line 88.
'export_fields' => array (
				'Product code' => array (
						'db_field' => 'product_code',
						'alt_key' => true,
						'required' => true,
				),
                'Product ID' => array (                 /* ADDED! */
                        'required' => false,            /* ADDED! */
                        'db_field' => 'product_id',     /* ADDED! */
                ),                                      /* ADDED! */


The above is what I did to include the unique Product ID used by CS-Cart to identify each and every product. This is then used instead of the product code in most cases - such as product combinations, multiple product images, etc.

I'm not sure if anyone else finds it strange, but why are Product Code and Product ID not available columns in EVERY type of import / export of data? It would make sense to me!

Cheers!


Updated: Added a topic poll... Well I tried to! "Error page not found!" (28th July 2012)


Thank you!


 
  • bartlby37
  • Advanced Member
  • Members
  • Join Date: 13-Mar 12
  • 86 posts

Posted 01 June 2012 - 04:54 PM #2

Bump - I want to be able to import tags

 

Posted 08 June 2012 - 09:18 AM #3

I think everything that is INSIDE CS-Cart should be accessible! It should be able to be EXPORTED and IMPORTED! (to a certain extent... :P)

For example, pages, links, content, etc, etc, etc.

Thank you!


 
  • clips
  • Aged Resident Loon
  • Members
  • Join Date: 14-Jan 07
  • 1650 posts

Posted 08 June 2012 - 03:57 PM #4

I agree with UniDevelopers. I really do not want to loose and of the bits and pieces that help the site flow and work better for users and search engine spiders.
Regards,
Jim

 

Posted 27 July 2012 - 06:10 PM #5

It really is bizzare that ALL fields are not accessible through import / export, under:
  • products,
  • product options,
  • combinations,
  • images
  • page content,
  • forms,
  • etc, etc!
How much faster and time would be saved if you could plug all your websites' data in locally on a PC then upload + import it, rather than entering it all via a web browser, waiting for each page to load! :P

I'd pay $50 for an "Add-on" that would override and improve the EXIM functions and files. If you think about it, it is really just the mapping of all tables and rows from the Database through to CS-Cart's Exim files. If someone has a solution, or willing to develop a solution, either modifying existing files or creating an add-on, I'd be more than happy to provide feedback, test, and generally assist development of it.

Once created, I'm sure a hell of a lot of people would be keen to save hours upon hours of their time by importing all their data, instead of importing some of it, then entering the rest of the data (e.g. tags) for 2.000 - 20,000 products!

I'm keen to hear + learn more for CS-Cart versions 2.2.x and 3.x.

Thank you.

:)

Thank you!