Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

First off - I'm still a newbie to OSC. Be kind ;-)

 

In my situation our website is fed from an upstream database. I won't go into all the details but essentially, I'd like to have the html based descriptions not get over-written in the OSC system when we do an Easy Populate import.

 

I have removed the field 'v_products_description_1' in Excel before the import so that it does not exist in the import file. We are only working in 1 language and all other languages have been removed in the setup. After importing the data in Easy Populate everything imports fine except all the description fields in the OSC db are set to "".

 

There is a section in easypopulate.php that implies that you can add in a field to "skip" and use the data in the database already but I can't seem to get it to work for the description field. Below is the snippet from the file that I've changed.

 

<section from easypopulate.php>

 

// these are the fields that will be defaulted to the current values in the database if they are not found in the incoming file

global $default_these;

$default_these = array(

'v_products_image',

'v_products_description',

 

</section from easypopulate.php>

 

In the above code I've tried v_products_description_1 as well with the same results described above.

 

In reading the source it looks like the description field is handled differently then some of the other fields and is a "mandatory" field. Does anyone know if this is the case? Any PHPer's out there willing to write a fix (I'll give it a try but not sure if I would be the best coder)

 

I've got a work-around in place by changing the UPDATE statement if a product is already in the database to not update the description field. It's working great but I'd like to see if there is a better way to do this (that I won't have to remember to do everytime Easy Populate is updated ;-)

 

Thanks in advance,

Bob

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...