==========================
The purpose of this tool is to allow "raw" data to be edited similar to the way you can edit in phpmyadmin, except much easier since its using the openfield CSV format. You can use Excel to edit the fields the same. Just be sure you save the files in csv format (as excel always offers to convert to xls for you).
This is not meant to be a replacement for the "Excel Import/Export" tool. That is a structured product import tool that correlates products, options, and more into one formatted structure. This means that changes to the database will need to coded into that mod.
This mod is "raw" by design to remove dependency on version or customizations to the database, and read it on-the-fly when generating the output. However, it can be used for product import (or any other field) but all individual tables need to be edited separately.
For example, if you want to add new coupons, you can export the coupon table, add your new coupons, and import it back in. But if you want to add new products, you need to export each of the following at a minimum:
product
product_description
product_to_store
product_to_category
In each of these, you must add the record of data, using the product_id as the primary key. It requires some general knowledge of mysql so it is more of an intermediate tool.
FREE DOWNLOADSupported OpenCart Versions:
================
v1.4.x
What does it do:
================
This contrib adds a new tool page for CSV Import/Export.
The mod will list ALL tables in a dropdown.
Choose individual tables to export in CSV format.
Edit the CSV file in an editor or Spreadsheet program (recommended)
Save and reimport the CSV file. It will replace the existing data with the new imported csv data
Main features:
==============
* Tables are Completely dynamic. Automatically gets the list of ALL tables, even custom ones
* Columns are also completely dynamic. All columns are found and listed, even custom ones
* Edit tables individually. This is a raw format editing tool which allows it to edit new fields at anytime without dependencies.
* Ignores columns that don't exist or that were left out purposely when reimporting.
How to install it:
==================
1) Unzip and upload the "admin" folder to the root of your OpenCart install. No files are overwritten
2) a. EDIT: admin/view/template/common/header.tpl
b. FIND:
----------------------------------------------------
<li><a href="<?php echo $backup; ?>"><?php echo $text_backup; ?></a></li>
----------------------------------------------------
c. AFTER, ADD:
----------------------------------------------------
<?php @$this->load->language('tool/csv'); ?>
<?php if (@$this->language->get('text_csvmenu') != NULL) { ?>
<li><a href="<?php echo (((HTTPS_SERVER) ? HTTPS_SERVER : HTTP_SERVER) . 'index.php?route=tool/csv&token=' . $this->session->data['token']); ?>"><?php echo $this->language->get('text_csvmenu'); ?></a></li>
<?php } ?>
-----------------------------------------------------
3) From the admin menu, go to 'Admin->Users->User Groups'. Edit the Top Administrator.
4) Find and check the new entries for both modify and access.
5) From the admin menu, go to 'System->CSV Import/Export'.
Usage Notes:
===============
- This is an atomic import. Meaning it deletes the data in the table before importing the new data. An Append mode is planned for a later date.
- The top row of the exported CSV files is in "table.column" format. Do not change these headings. You may, however, remove complete columns that you don't want to import. These will just be left blank.
- Microsoft Excel is a good CSV editor, but erroneously converts the date column to "xls" format. I do attempt to correct this behavior programmatically but the feature is in beta and may or may not work. In the case it does not work, you will likely see a date of 01/01/1970 which is the default date mysql uses. Please report cases of this when noticed.
- This tool is for raw editing of table data. Do not delete or change any "ID" columns as they are used to link to other tables for extra data
- This tool is designed to be dynamic performance may or may not be affected. Performance is not the goal since it is on the admin side. Dynamic functionality is the goal.
I've not tested it on large databases yet, but because it uses individual tables, it may be able to handle larger amounts of data. Anyone with a large store and some intermediate know-how, please let me know.
Best $130 I ever spent 
?
