step needed for setting up cscart integration with control

install cscart 2.0.14 , any other version is used , update needed to be done on the cscart_patch-2.0.14.tgz to work with a new version.
configure gencont so we write allow update the dblog, we need the log for the update process,
input internet location in gencont
configure coaad to allow update of cscart
configure coaad put the database , login and password for the cscart database in to control
make sure the user on control machine can login to the mysqld on the cscart machine,
patch the cscart source directory by untar cscart_patch-2.0.14.tgz under the source directory the cscart version need to be 2.0.14
after untar make sure the order_sh and user_sh is executable by apache the order directory is readable and writable by apache
change order_sh and user_sh so they use the correct CCDIR server related env, COMPANY and BRANCH and terminal ID
setup the terminal ID which used by the script in control to use the correct COMPANY and BRANCH
set up control category so it use the alphabetical order to determine sub directory
create three directory category/ detailed/ product/ thumbnails under $CCDIR/COMPANY/webimages/LOCATION/
if cscart installed on the same server with control link these three directory with ones in cscart_source/images/
Don't forget to set the internet location (in gencont last time it moved)
if not on the same server setup cron job to rsync the thrss directories from control machine to cscart server machine
If on 3.x and up, make sure to disable_block_cache=true. The default is false and this would make changing the "show on web" option on categories have no effect on the site.
need to delete all the image in the product/ and detailed/ if not dumping the first time

run

fdb2log -i -B [INTERNETLOCATION] -a 8 -a 9 -a 65

then run
```
 log2cscart -I
```
done , cscart should work and is intergrated with control , check by changing stock desc on an item and the same produce's name on the cscart should change as well
if any process not working, check error.log for hints.

If your captcha is not working make sure you have gd, php-gd, and freetype installed

If thumbnails do not update

make sure the thumbnails dir is mounted, since control will try to find the old thumbnails and delete it and cscart should generate new thumbnail upon http request.
ssh into the web server and cd into their skins directory
```
 #cd /var/www/html/cscart/skins
```
You can edit a list of files that use show_thumbnail using the command.
```
 #vi `grep -r show_thumbnail * | cut -d\: -f1 | sort | uniq | xargs`
```
You want to change "Y" to "N" in those lines.

To use parent image when child has no image:

login to cscart admin page
Select Design tab
select skin-selector sub-tab and check what skin they currently use
select template editor sub-tab
follow these folders: <skin_name> -> customer -> views -> products -> components
double click product_options.tpl

Replace the line

'src': '{config.no_image_path}',

with

'src': '{$image_pair_var.icon.image_path}',

Note that zoomifier (3rd party add-on) will always use the parent image as it is not child-aware.

To remove the Simbirsk Technologies details

Go to Admin -> Company. Set this up with proper details for the company. This is used in numerous parts of the program.

To make the left column show level 1 and level 2 categories simultaneously on the left column

Go to Admin Page -> Design -> Blocks. On the left column expand the "Categories" field and click on "edit". Choose Plain in the Filling field then save.

To clear the cache (or thumbnails)

Go to Admin Page. Add ?cc to the URL to clear cache. Add ?ct to the URL to clear thumbnails.

If images stop loading (cscart 2.x and up)

This is very likely caused by the AUTO_INCREMENT value in some of the tables have reached their upper limit. The tables names are cscart_images and cscart_images_links. You have to use mysqldump to back up these tables:

"su -" to root. And disable the "incremental_cscart" process in the /etc/inittab. Save the changed /etc/inittab file. and issue "init Q". Then "ps -lef | grep cscart" to make sure no incremental_cscart process running.

Then:

mysqldump -u [username] -p [db_name] cscart_images >imagesbackup.sql
mysqldump -u [username] -p [db_name] cscart_images_links >imageslinksbackup.sql

You have to manually edit the files and look for:

Engine=MyISAM AUTO_INCREMENT=[some large number] DEFAULT

Change [some large number] to a reasonable number after deleting data from the end of the file. Then re-import this file

mysql -u [username] -p [db_name] <imagesbackup.sql
mysql -u [username] -p [db_name] <imageslinksbackup.sql

Alternatively, you can (if you have an idea what number to reset to) do it all from mysql:

mysql -u [username] -p [db_name]
[enter password]
delete from cscart_images where image_id>[number to reset to]
delete from cscart_images_links where image_id>[number to reset to]
alter table cscart_images_links AUTO_INCREMENT = [number to reset to]
alter table cscart_images AUTO_INCREMENT = [number to reset to]

at this point, whether you did export/import or the mysql method, all images would disappear from the site. You need to delete all images in the images/detailed/ directory and then redump all the stock (don't use the -i option in fdb2log, and don't use the -I option for log2cscart)

cd /u/cc/[company directory]
cp ../standard/dblog.dat .
fdb2log -B [location] -a 9
log2cscart

Verify that the images are reloaded in the customer's website. re-enable the log2cscart in "/etc/inittab".

"su -" to root. And enable the "incremental_cscart" process in the /etc/inittab. Save the changed /etc/inittab file. and issue "init Q". Then "ps -lef | grep cscart" to make sure log2cscart process is running.

If you find staad/stgaad does not save your web descriptions:

First make sure there is a webnote subdirectory under the company. Also if you have multiple locations, make sure the LOCATION directory is under webnote. If this is already there and you find .inter files in it, make sure you load a copy of "fixdeg" from the binl directory.

Don't forget to create a new default online debtor from scratch so that all the owings are 0

Using external data source.

Instead of using Control data, it is possible to set up the use of an external data source such as ACCPAC. If the online location for the store has this set up in the branch record, then a different updater called "acc2csmin" will need to be run regularly in place of log2cscart. Since we have no notification on when these quantities change, the updater has to be run at regular intervals. acc2csmin only updates the quantity of items set to "S" and those that have a supplier stock code (#1). If item is a kit, it will automatically query for the components and update the number of kits that can be put together based on them.

If you get an error message in website "Error Occured"

The fix is just the REPAIR the tables.

The MySQL commands are:

mysql -u cscart -p <dbname>
<type password here.  It's a secret>
REPAIR TABLE cscart_sessions;
REPAIR TABLE cscart_seo_names;

<dbname> is bodycart or bodyfactorycart

If you need to login to purchase a cs cart license from the web store

Our "tech support" credentials is:

Password:

AspaceSecret123