Open Shop v2.0

[rentasite]

you can upload your own license keys files with any keys you want...

Σωστός! 

[Amigamerlin]

Hello Datahell, just starting using Open Shop so my request can be obsolete but anyway .

I would like to suggest a Bulk import procedure for product using CSV or xls files ... if it's not already implemented  .
Jointly with Cron can be a great thing to have always synchronized price, quantity, from warehouse with the eshop.
Moreover will let user import 1000 or more product in a really simple way.
Let me know if can be possible to do.

[datahell]

Latest features implemented: Create pdf invoices, Excel export instead of csv, income report like an official logistics book (can be exported as excel too), mail pdf invoice to customer. More are coming

[datahell]

Import csv: More problems than solutions with this of the csv is freely generated. Maybe migration from an other specific shop system would be a better idea. In any case I cant do that now.

[Amigamerlin]

Impressive job !!!...
Count on me for italian transaltion !!!

About import csv or xsl. I've experience with prestashop that has CSV import function and it works pretty good.
Prestashop release the template with the first line filled; user should adapt his warehouse according the template filling the other line.
That's all !!!

IMHO using a generic way for importing product give us a great opportunity to migrate from another eshop or insert a lot of product in a really simple way.

Thank you for your attention.

[Amigamerlin]

Ciao Datahell here another useful (IMHO) request for the next Openshop:

Availability to can specify another e-mail adress where the Open Shop orders are sent. Currently order are sent to the site administrator e-mail but many times Site tech reference is not the same of the sales office.

Let me know about this request too.

Thank you in advance.

[Amigamerlin]

Ciao Datahell,
Always IMHO another useful option is to have an option that hide the price to all not registered users. Then to see the price user registration is required.

Shortly:

1) Bulk product Import option / procedure for massive product insertion using csv or xls;
2) Option to add another e-mail address specific for orders where the order taken from online ehop will be sent;
3) Option to hide price for not register users.

That's all  .

Thank you!!!

[datahell]

I attach screenshot of sample PDF invoice generated by Open Shop v2.0. The screenshot is smaller than the original dimensions.

Note 1: The invoices numbering format changed from E-{ID} to {YEARx}{MONTHx}-{IDx}
Where
YEARx: A for 2016, B for 2017, C for 2018, etc..., when Z letter is reached it starts back from A. For example for 2015 YEARx is "Z"
MONTHx: First 2 letters of order month. JA for January, FE for February, etc..
IDx: Incremental invoice number 0 padded (5 digits length minimum).

So for example invoice number BAU-00023 is the 23rd invoice in total of an order in August 2017.
AAP-00012 is the invoice number 12 of April 2016.
So all invoices of a year will start from the same letter.
Open payment invoices follow this format: OPN-{IDx}

Note 2: PDF invoices also have a barcode following the Code 128 method (Europe's standard EAN only supports digits this is why I picked C128).

[datahell]

Open Shop v2.0 released and you can download it from EDC.

All Open Shop related extensions

My personal site re-built with open Shop 2

Licensing Management System for Open Shop v2.x

[chongbing]

It's a BIG NEWS!  Great job!

Thank you datahell.

[Amigamerlin]

Good new !!

First little problem:
Trying to update from 1.6 I've got this error:
ERROR in file /web/htdocs/www.algostream.cloud/home/components/com_shop/install.php line 112 Call to a member function getConfig() on a non-object

[datahell]

Oooops! I will fix it later as I am out of office now. If the installation was OK and you dont see errors when you edit/save products then you dont have to do anything.

Else login in phpmyadmin and execute the following SQL queries:

Code: [Select]

ALTER TABLE `elx_shop_products` ADD COLUMN `callforprice` TINYINT(3) NOT NULL DEFAULT 0;
ALTER TABLE `elx_shop_products` ADD COLUMN `docfile` VARCHAR(180) DEFAULT NULL;
ALTER TABLE `elx_shop_products` ADD COLUMN `doclink` VARCHAR(180) DEFAULT NULL;
ALTER TABLE `elx_shop_products` ADD COLUMN `licperitem` SMALLINT(3) NOT NULL DEFAULT 0;
ALTER TABLE `elx_shop_orders` ADD COLUMN `dataprivate` TEXT;
ALTER TABLE `elx_shop_orders` ADD COLUMN `datacustomer` TEXT;
ALTER TABLE `elx_shop_openpay` ADD COLUMN `dataprivate` TEXT;
ALTER TABLE `elx_shop_openpay` ADD COLUMN `datacustomer` TEXT;
Sorry for the trouble.

[datahell]

Open Shop v2.0 updated to revision 64 (13-01-2016).

In comparison to the original release v2.0 rev60 the following changes were made:

Fix: Missing variable in installer during component update from v1.x to v2.0
Fix: SQL query for Piraeus ePOS payment gateway
Fix: SQL query for Alpha bank e-Commerce payment gateway
Update: Help file updated for v2.x Open Shop


Modified files:
components/com_shop/includes/pm/alphacom/alphacom.php
components/com_shop/includes/pm/epos/epos.php
components/com_shop/includes/help.txt
components/com_shop/shop.xml
components/com_shop/install.php

To update re-download Open Shop and overwrite the modified files on your installation.

Note:
As Open Shop v2.0 is a massive upgrade of version 1.x some initial small problems might exist. If you notice something wrong please notify me to fix it.

[datahell]

Open Shop updated to version 2.1 (rev70).

In this version:

• Added option to set custom invoices prefix.
• Added option to set custom email address for store. Orders will be send to this e-mail address.
• Order emails are now send in both plain text and html format.
• Added reply to address in emails sent by shop (requires Elxis 4.5 rev1909 or newer).

Download from EDC:
https://www.elxis.net/edc/ecommerce/110.html

[rentasite]

Why does the admin receive Notifications of orders, twice in his email?