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.
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?
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.
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, 3 months ago by
wpgirl21.
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.
