[A code page for import/export files]

2 hours ago, bsmither said:

A better solution would be to get an "External"-type extension. Here are a couple:
https://www.cubecart.com/extensions/product-feeds/data-pump-import/update/export
https://www.cubecart.com/extensions/product-feeds/storeya-export

But you can try this (I have not actually tried this myself):

In the administrative folder, /sources/products.export.inc.php, near line 145, find:

deliverFile(false, false, $output, $filename);

Change to:

deliverFile(false, false, chr(bindec('11101111')).chr(bindec('10111011')).chr(bindec('10111111').$output, $filename);

 

Great thank you. I changed the code and it works. Only one small addition - you forgot one bracket.

The correct code is:

deliverFile(false, false, chr(bindec('11101111')).chr(bindec('10111011')).chr(bindec('10111111')).$output, $filename);

Could you be so kind to advice me how it would be easier to create a correct .csv file for Import?

If I save my .xls file as a .csv in Excel, it creates it not in UTF-8 :-(

I found a temporary solution - save .xls as a Unicode text, replace all tabulations on commas, and rename .txt to .csv ... But it really annoys me.

Thank you!

 

[A code page for import/export files]

3 minutes ago, bsmither said:

By design, CSV files do not have any kind of language or codepage identifiers. Characters represented by UTF8 code points will appear as their full two, three, of four byte sequences. It is up to the application displaying the data to figure this out -- either by inspection or by a default setting for loading the file.

UltaEdit does this by looking for obvious UTF8 byte sequences within the first 16K (maybe 4K, maybe 256K, I do not recall) of the file's contents. UltraEdit also honors the file's first two bytes, if present, called the Byte Order Mark (BOM). When having UltraEdit save this file, the settings may be such that UltraEdit adds the BOM to the file.

This, in turn, allows Excel to honor the BOM and display the contents appropriately. Excel does not do content inspection.

The BOM is really to indicated '-endian' format, and may mess up other readers. But it will let Excel display the file correctly.

The CubeCart code that writes the CSV can be modified to output the BOM.

Wow! Thank you for so detailed answer! Where can I find a piece of code in the CubeCart to change it to output the BOM?

[A code page for import/export files]

Hi!

I use Russian symbols in the "product name" field and it shows without any problem everywhere.

However, when I export catalog and open it in Excel Russian symbols are shown wrong. If I open .csv file in UltraEdit and save it as UTF-8 file then it is opened in Excel without any problems. But I don't know what is original code-page of .csv file to use external converters (UltraEdit recognizes it automatically).

Could you be so kind to give me the clue what code page is use by default in .csv file and is it possible to change inside CC615 it to avoid additional manual convertation?

Thank you.

[How to add manufacturer field to area of search]

1 hour ago, havenswift-hosting said:

If you want to enhance the functionality of manufacturers then take a look at our plugin which is available from our website here : https://www.havenswift-hosting.co.uk/clients/cart.php?gid=19

The added functionality is as follows

Enhanced Manufacturers 
This plugin greatly enhances the very limited built in manufacturers functionality within CubeCart. Specific features include :

* manufacturers displayed either in a drop down box or displayed as a list in a sidebar box 
* each manufacturer has their own page, which can be edited to show the manufacturer details and all products assigned to that manufacturer
* a link to the new manufacture page is displayed on the product page
* when browsing categories, or in search results, there is a filter by manufacturer which only show manufacturers for products which are actually in stock.

When adding/editing a manufacturer you can:
- set the status
- set the order
- set a description
- set an image
- set SEO fields (title, description, keywords)

As with all our plugins and skins, this plugin comes with one year of support and access to upgrades included in the price

Thank you for an offer. However, in addition to the manufacturer field, I also want to do same with other fields which I added (Author, Series and etc.). So , it will be necessary to modify your plugin. As a result, firstly I spend money and after that I spend time. It will be more beneficial for me just spend time and do everything by my own.

[How to add manufacturer field to area of search]

7 minutes ago, bsmither said:

Welcome SergeiG! Glad to see you made it to the forum.

In CC615 (maybe CC614 as well), the Advanced Search page (in the Foundation skin) should give you a selector to filter by Manufacturer.

It will be difficult to include the manufacturer's name in the Quick Search field, as only the 'manufacturer_id' number (as a key into the manufacturers database table) is available in the Inventory table, where the search is performed.

 

Thank you for respond. Currently, I try to tune the CC615. If I use the Advanced Search and choose a Manufacturer, I must to enter something as a search keyword. However, my goal is next - I want to receive a list of all products from one manufacturer. May you recommend how to achieve this goal?

[How to add manufacturer field to area of search]

Hello!

As I found, when I use a search form it use only product name and product description fields as an area for search. I would appreciate if you help me to add the manufacturer field to an area of search.

For example, I have a products by 'QQQ' manufacturer (without 'QQQ' in names and descriptions). I want to enter 'QQQ' as a search keyword and receive a list of this products as a result of search request.

Thank you.