Title: importing product data query
Last modified: February 4, 2021

---

# importing product data query

 *  [wpgirl21](https://wordpress.org/support/users/wpgirl21/)
 * (@wpgirl21)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/importing-product-data-query/)
 * hi so i have a question and its really been bugging me as to how it should be
   done. So my job have thousands of products and various suppliers. in order to
   add the html tags, classes etc to the descriptions for the csv file, is there
   a program out there that can do this? rather than manually editing all the supplier
   data one by one.
 * would be very grateful for any help with this
 * thank you

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/importing-product-data-query/#post-14012983)
 * Adding HTML tags and classes to a CSV file sounds like the wrong approach. How
   will this data be ultimately used? What normally happens with CSV data is it 
   is imported into a mySQL database where data can be efficiently queried. The 
   query results are then processed for output to a browser, where appropriate HTML
   is dynamically added as part of the processing code.
 *  Thread Starter [wpgirl21](https://wordpress.org/support/users/wpgirl21/)
 * (@wpgirl21)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/importing-product-data-query/#post-14014954)
 * thank you for your response.
 * > Adding HTML tags and classes to a CSV file sounds like the wrong approach.
 * Im mainly refering to the product description part of a product line. do you 
   know how large wordpress websites with lots of data manage to put all their product
   description data up? say some of the descriptions will need to be in a table,
   an unordered list, or to add say the h2 tag to a heading, to embolden a heading
   etc? Am i overthinking it? For example one of their suppliers has 10,000 products,
   alot of them are variants. what would be the best method of uploading the description
   section of their products?
 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/importing-product-data-query/#post-14015614)
 * The limitation of data for WP depends on your DB hardware. This forum is WP based,
   naturally. It currently has something like 13 million posts in its DB. There 
   are even larger sites. They utilize some hardcore DB servers. What’s possible
   with a typical shared hosting account is much more modest.
 * How is the data maintained? You’d want to get the data directly from the maintained
   source if at all possible. You’d want any modifications to the data for enhancing
   its appearance to be done dynamically through a template of some sort. For example,
   maybe a product name is “Super Widget”. A template could take that and output`
   <h2 class="product-name">Super Widget</h2>`. You don’t want to add the same H2
   HTML 10,000 times over to every product name in the file or DB. Let the template
   do it on output.
 *  Thread Starter [wpgirl21](https://wordpress.org/support/users/wpgirl21/)
 * (@wpgirl21)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/importing-product-data-query/#post-14017989)
 * thank you
 * in relation to:
 * > You’d want to get the data directly from the maintained source if at all possible
 * Do you mean from the supplier?
 * And this:
 * > You’d want any modifications to the data for enhancing its appearance to be
   > done dynamically through a template of some sort
 * this is the thing i have no idea where to look for? im totally on my own with
   this & the business owners arent tech savvy. By ‘template’, do you mean a plugin?
   Or a program?
 * thanks again
    -  This reply was modified 5 years, 4 months ago by [wpgirl21](https://wordpress.org/support/users/wpgirl21/).
 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/importing-product-data-query/#post-14020425)
 * In the WP world, templates go with themes. This sort of thing may require a custom
   template. If that’s the case, it belongs in a child theme you would create to
   go with your chosen parent theme.
 * > Do you mean from the supplier?
 * Well, the supplier isn’t going to allow you to edit their data of course. Depending
   on the supplier, it might be possible to access their data through an API of 
   some sort. Yours and their servers talk to each other to get the data needed 
   for any particular page request. Some industries are quicker than others to adapt
   an API model, you may be stuck with a CSV type of data distribution.
 * There are plugins to help you import CSV data into a database table. You’d then
   need code to query the DB, then use the results to generate output through a 
   template that’s used to add all the standard HTML that’s used on every page. 
   You’ll have different templates for different kinds of pages.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘importing product data query’ is closed to new replies.

 * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/)
 * 5 replies
 * 2 participants
 * Last reply from: [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * Last activity: [5 years, 4 months ago](https://wordpress.org/support/topic/importing-product-data-query/#post-14020425)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics