Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Updating Description HTML via Import

 
Reply
   X-Cart forums > X-Cart 5 > General questions (X-Cart 5)
 
Thread Tools Search this Thread
  #1  
Old 02-19-2019, 11:29 AM
 
Matthew Moran Matthew Moran is offline
 

Newbie
  
Join Date: Jan 2019
Posts: 6
 

Default Updating Description HTML via Import

I've had a few instances where complex HTML descriptions break the cvs upload file. I am curious how people update many product descriptions - particularly those with any complex HTML?

Also, I'm curious how you might be writing the HTML descriptions for your products - if you are doing it offline?

I've successfully connected a desktop app to my MySQL db and can use that to upload product description data - though I do so with some trepidation. I only do so after products have been created and I have the ID. I don't generate any new products this way.
__________________
Matthew Moran
v. 5.3.6.0
https://PulseInfomatics.com
Reply With Quote
  #2  
Old 02-27-2019, 06:09 AM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: Updating Description HTML via Import

Hello Matthew.
I import HTML using the embedded CSV import/export feature, and it hasn't broken anything so far.
I am attaching a CSV file that I justed tested, and it worked perfectly.


Maybe there is something specific that breaks the layout in your CSV file.

Please send it here, I will have a look.
Attached Files
File Type: csv products-2019-02-27.csv (9.4 KB, 185 views)
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote

The following user thanks qualiteam for this useful post:
Matthew Moran (03-04-2019)
  #3  
Old 03-04-2019, 08:06 AM
 
Matthew Moran Matthew Moran is offline
 

Newbie
  
Join Date: Jan 2019
Posts: 6
 

Default Re: Updating Description HTML via Import

Hi Alex,

I just got around to looking over the csv file. I have created fairly complex HTML and been able to update via csv - though, it still makes me nervous.

I do have a question about scalability. If you are updating hundreds of products, how are you creating the csv file?

Currently, I'm creating an HTML template that will be used for most of my client's products - with specifics pulled from a SQL database we are developing for their in-house sales and management team to update. Based on the data they input, the product description information is updated using the template.

In any case, how many products do you update or manage this way and how do you update your csv file efficiently?

I posted another question and am curious also about how others might be updating open graph data as well. Again, at this point, I've created an in-house tool that generates custom open graph data for the title, description, and default image.
__________________
Matthew Moran
v. 5.3.6.0
https://PulseInfomatics.com
Reply With Quote
  #4  
Old 03-06-2019, 09:58 AM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: Updating Description HTML via Import

I don't update many products actually, something around 50.
I think it is better to ask store owners how they do it.

How many did you have when it broke the import?
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote
  #5  
Old 03-06-2019, 10:24 AM
 
Matthew Moran Matthew Moran is offline
 

Newbie
  
Join Date: Jan 2019
Posts: 6
 

Default Re: Updating Description HTML via Import

Hi Alex,

Isn't this forum where I would ask other store owners? If so, consider the question asked.

It wasn't the number of products being updated, it was creating/updating the HTML to be well-formed in a cell in Excel to ensure it remains in the proper column.

If a mistake is made with a comma outside of a quotation mark, it becomes pretty simple to break the upload. Plus updating those HTML descriptions has it's own challenges when considering updating several (100-500) products at once.

At this point, we either have an HTML document with sections (using ID's) that includes the short description and the expanded description. I can extract those HTML sections by product for a given upload and write directly to the MySQL DB or add these sections to a csv (Excel file) based on the sku.

But still working out the management for my client.

Thanks.
__________________
Matthew Moran
v. 5.3.6.0
https://PulseInfomatics.com
Reply With Quote

The following user thanks Matthew Moran for this useful post:
qualiteam (03-11-2019)
Reply
   X-Cart forums > X-Cart 5 > General questions (X-Cart 5)


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 03:48 PM.

   

 
X-Cart forums © 2001-2020