CLI tool linking between pims and opencart
Features (unchecked are TODO)
- Read pims export csv and display as yml
- Read opencart mysql database and display data similar to yml of pims csv export
- Validate opencart: list products without categories, without image (issue 1)
- Reconcile quantities between pims csv and opencart mysql database (issue 2)
- Reconcile categories and category products between pims export and opencart database (issue 3)
Download your computer architecture's corresponding binary from the releases.
e.g. for linux
dpkg --print-architecture
wget https://github.com/shadiakiki1986/pims-opencart/releases/download/0.0.1/pims-oc-amd64 # if above displays amd64
sudo chmod +x pims-oc-amd64
sudo mv pims-oc-amd64 /usr/sbin/pims-oc
- Read pims csv export:
pims-oc read:pims pims.csv
pims.csv
is the excel file of inventory by item exported from pims 2, and then saved as csv manually- Produces tabular output
- Read opencart database:
pims-oc read:oc <DSN>
- DSN is as exemplified on
go mysql driver:
e.g.
user:password@/dbname
- Produces tabular output
- Includes field of warnings per product
- To filter output for warnings only:
pims-oc read:oc --warnings <DSN>
- Reconcile:
pims-oc recon pims.csv <DSN>
- mysql users on a2hosting are only allowed from
localhost
- so it is a restriction in order to limit users connecting to the database from the local machine after ssh'ing into it
- It is still possible to access the mysql database from outside of the a2hosting server by using a SSH tunnel
ssh -L [local port]:[database host]:[remote port] [username]@[remote host]
- forward the a2hosting 3306 traffic to your local 3307 port for example
- Ref: https://support.cloud.engineyard.com/hc/en-us/articles/205408088-Access-Your-Database-Remotely-Through-an-SSH-Tunnel
Alternatively, just export your opencart mysql database as documented here below and import it locally
Dependency mysql requires go version > 1.2 (note on ubuntu 12.04 you get go version 1)
Install dependencies
sudo apt-get install golang
mkdir ~/.go
export GOPATH=~/.go
# https://github.com/Go-SQL-Driver/MySQL/#usage
go get github.com/go-sql-driver/mysql
# https://github.com/urfave/cli#using-the-v2-branch
go get gopkg.in/urfave/cli.v2
# https://github.com/go-yaml/yaml
go get gopkg.in/yaml.v2
# https://github.com/gosuri/uitable
go get -v github.com/gosuri/uitable
- create an opencart empty db
sudo apt-get install mysql-server
mysql -u root -p -e 'CREATE DATABASE opencart'
mysql -u root -p opencart < test/create.sql
- export existing opencart database
- Click on settings .. export
- download
store.sql
- rename the table prefix from
ocko
tooc
:sed -i "s/ocko_/oc_/g" test/store.sql
- import
test/store.sql
into the opencart db created
mysql -u root -p opencart < test/store.sql
Note on create.sql
- Copied from opencart repo
- Create tables for opencart
- https://github.com/opencart/opencart/blob/master/upload/install/opencart.sql
wget https://raw.githubusercontent.com/opencart/opencart/master/upload/install/opencart.sql -O test/create.sql
Copied from gosu
CGO_ENABLED=0 GOARCH=amd64 go build -v -ldflags '-d -s -w' -o bin/pims-oc-amd64
CGO_ENABLED=0 GOARCH=386 go build -v -ldflags '-d -s -w' -o bin/pims-oc-i386
where amd64 is from dpkg --print-architecture