Elxis CMS Forum

Extensions => Components => Topic started by: datahell on November 11, 2016, 20:44:31

Title: Open Shop v2.0
Post by: datahell on November 11, 2016, 20:44:31
I announce you begin of development of Open Shop v2.0

1 new feature and 1 new configuration option already added:

- Added Price Policy for all products. Values: Normal or Call for price.
If set to Call For Price then product price is not visible and the product cannot be added into cart. Instead an Add A Quote form will be displayed to the customer. This can be VERY USEFUL to products such as custom services which as difficult to tell an exact price before contacting the customer (eg paint of a house, seminars, custom web development, etc)

- Added configuration option to hide tags in product's page.

Open Shop v2.0 will have more exiting new features* and a brand new design. Stay tuned!
If you have a feature request you may post it below.

* A feature that I plan to add is this: Option to add dynamic characteristics into a product cart item. Here is a usage example to understand why this can be VERY helpful: You have a product named "Domain registration". The customer can add it into a cart and buy it but you dont know which domain he wants to register. By using a dynamic attribute you can attach a custom characteristic (domain name) to this cart item.
Title: Re: Open Shop v2.0
Post by: rentasite on November 14, 2016, 00:15:00
Great news!

- I like the "Call for price" feature. Will this be a Global setting or it can be applied separately for individual products??
- Also the "Dynamic characteristics" will be very useful.

My requests:

1) As previously discussed  :) that double click for the 3 buttons (add to cart, add to wishlist, add to compare list) should change and be more user friendly. Because many can not understand that by double clicking will lead them to another page.
2) Improvement in the way the Offers are displayed on eshop's home page.
Title: Re: Open Shop v2.0
Post by: datahell on November 14, 2016, 18:12:49
"Call for price" can be applied to individual products. If it would be for all products then there would be no difference with the "Products catalog" option. So you can sell products A, B, C online and for products D, E display an inquiry form. This new feature is almost ready!

One new feature is been added that solves any display/style/functionality request: Open Shop templates. The "CSS" configuration option (by default "ios" style) changed to "Template". Open Shop templates are not limited in applying custom CSS, they can set custom HTML, javascript and functionality. Although to do such things requires some custom development you have the option to do it without modifying Open Shop source code.

Notes: v1.x "ios" CSS style will be converted to a v2.x template so if you use that option you will not have display changes to your site if you update from v1 to v2. If you use an other custom v1.x CSS style you will have to either use a v2.x template or convert it to a v2.x template. The "agora" template will be commercial.
Title: Re: Open Shop v2.0
Post by: web-infox on November 15, 2016, 13:46:34
Μέθοδοι αποστολής και με Αντικαταβολή
Μέθοδοι πληρωμής και Τράπεζα Πειραιώς
Φίλτρα
Εισαγωγή XML από άλλη πηγή
Ομάδες τροποποιητών (υποχρεωτικό ή όχι)

 
Title: Re: Open Shop v2.0
Post by: bledi on November 15, 2016, 19:06:18
Hello datahell!
Can you add also a calendar plugin, to rent (or buy, or deliver) the products at certain date.
regards
Title: Re: Open Shop v2.0
Post by: web-infox on November 23, 2016, 20:29:46
Μπορει να γινει  quick view

Ευχαριστώ
Title: Re: Open Shop v2.0
Post by: perseas on November 24, 2016, 21:12:16
Θα εξυπηρετούσε πολύ να προστεθεί στις μεθόδους πληρωμής η υπηρεσία ePOS Paycenter της Τράπεζας Πειραιώς [www.piraeusbank.gr/el/epiheiriseis-epaggelmaties/e-shop]
Title: Re: Open Shop v2.0
Post by: rentasite on November 25, 2016, 14:13:11

Two recommendations from my experience of using Open shop, concerning the administration:

- Ability to copy products. As we can copy articles in Elxis CMS.

- This is when it comes to several products and you must add even more! After you create and save the new product, the product's listing brings you to the first page. It would be very useful to lead you to the page where the latest product is displayed.
Title: Licenses manager for Open Shop v2.0
Post by: datahell on November 27, 2016, 20:34:47
Added licenses manager (LMS) for downloadable products. Licenses get generated in Open Shop based on multiple complex validation criteria you freely set. When you sell a product a license key is released and assigned to the customer automatically. The key is marked as "sold". Keys can also be marked as "Used" (built mostly for automated remote licensing activation systems). You can also manually change the status of a license key. Each product can have its own license keys. See screenshot on my Twitter (https://twitter.com/IsOpenSource/status/802941014017241088)

Copied from Open Shop related help:

Generated license keys are alphanumeric (A-Z, a-z, 0-9). You can set rules for validating purposes on generated keys. For example you can set the forth character to always be a letter (4:letter[A-Z]) or an integer greater than 5 (4:int[6-9]). You can also set mathematical sum rules. For example the sum for the 3rd and 7th character to be less than 12 (3+7:sum[0-11]) or the sum of all characters to be greater than 199 (all:sum[200-10000]). Note that letters can also be added in math operations. Their arithmetic value is based on an IOS cryptography algorithm (A=12, B=16, C=19, ..., Z=87). If you put too many, or too hard, rules then there might not be enough valid keys to generate.

The 2nd character should be a number greater than 7  2:int[8-9]
The 2nd character should be number 7 2:int[7]
The 2nd character should be a letter  2:letter[A-Z]
The 2nd character should be letter K  2:letter[K]
All characters should be integers  all:int[0-9]
All characters should be letters  all:letter[A-Z]
The sum of character 2 and 5 should be greater than 5  2+5:sum[6-100]
The sum of character 2 and 5 should be less than 8  2+5:sum[0-7]
The sum of all characters should be greater than 200  all:sum[201-10000]
Title: Re: Open Shop v2.0
Post by: rentasite on November 27, 2016, 23:09:11

WoW !!!  :o
Title: Re: Open Shop v2.0
Post by: chongbing on November 28, 2016, 18:13:21
Great job datahell !
Title: Re: Open Shop v2.0
Post by: datahell on December 01, 2016, 21:56:30
Updated development report for Open Shop 2.0

- Each product can have an after sales information link.
- Each immaterial product can have additionally a download-able documentation file.
- Each download-able product can have additionally a download-able file.
- Each immaterial/download-able product can have license keys using the Open Shop LMS extension (you can set how many per item, so you can create groups like 3 licenses pack).
- Local/Server/No SSL certificate option for automated payment tasks (like Paypal). Added Mozilla's PEM certificate file for PHP's CURL
- Payment transaction data as well as other information are now saved in order. There are 2 texts, one for the customer and one for the site administrator.
- Open Shop control panel has a new look.
- Elxis displays a full Open Shop menu in administration area under Extensions > Open Shop
- When you manually set an order as paid then can initialize the automated payment tasks without an online payment method (eg send downloadable products links and licenses to the customer) - this is still under development
- Much more changes...
Title: Re: Open Shop v2.0
Post by: rentasite on December 01, 2016, 22:46:30

According to what im reading, this is going to be a great update! :) Thank you very much Gianni
Title: Re: Licenses manager for Open Shop v2.0
Post by: rentasite on December 07, 2016, 22:34:55
Added licenses manager (LMS) for downloadable products. Licenses get generated in Open Shop based on multiple complex validation criteria you freely set.

Could there be a function,  in order the administrator/seller to manually input License codes for sale?
Title: Re: Open Shop v2.0
Post by: datahell on December 07, 2016, 23:07:07
You manually set the generation rules but the keys themselves are generated automatically and saved in a special file. However if you dont want the automatic license keys generation feature you can upload your own license keys files with any keys you want... My recommendation is to use the automatic generated ones because, most probably, they will be better than yours as their generation follows mathematical and cryptography methods.

Note that this feature is already complete.

BTW some newer additions and improvements already implemented and finished:
1. CSV sales reports export replaced by Excel documents (xlsx).
2. Added statistical graphs
3. The administration css became almost images-free due to the usage of font awesome (Open Shop is compatible with Elxis 4.5 or newer)
4. Documentation file (downloadable) can be attached to immaterial products.
5. Information link can be attached to any product.
6. You can manually begin the "mark as paid" process from the admin area. This process mimics an online payment functionality (sends mail to the customer, invoice, download-able goods, etc).
Title: Re: Open Shop v2.0
Post by: rentasite on December 08, 2016, 00:34:41
you can upload your own license keys files with any keys you want...

Σωστός!  ;)
Title: Re: Open Shop v2.0
Post by: Amigamerlin on December 12, 2016, 10:01:33
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.
Title: Re: Open Shop v2.0
Post by: datahell on December 12, 2016, 18:05:35
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 :)
Title: Re: Open Shop v2.0
Post by: datahell on December 12, 2016, 18:09:10
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.
Title: Re: Open Shop v2.0
Post by: Amigamerlin on December 12, 2016, 18:18:39
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.


Title: Re: Open Shop v2.0
Post by: Amigamerlin on December 12, 2016, 18:24:13
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.
Title: Re: Open Shop v2.0
Post by: Amigamerlin on December 12, 2016, 20:53:22
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!!!
Title: Re: Open Shop v2.0
Post by: datahell on December 15, 2016, 21:43:37
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 (https://en.wikipedia.org/wiki/Code_128) method (Europe's standard EAN only supports digits this is why I picked C128).
Title: Open Shop v2.0 released
Post by: datahell on January 09, 2017, 19:48:02
Open Shop v2.0 released and you can download it from EDC.

All Open Shop related extensions (https://www.elxis.net/edc/tags.html?tag=openshop)

My personal site (https://www.isopensource.com) re-built with open Shop 2

Licensing Management System (https://www.isopensource.com/shop/software/10.html) for Open Shop v2.x
Title: Re: Open Shop v2.0
Post by: chongbing on January 10, 2017, 00:22:26
It's a BIG NEWS!  Great job!

Thank you datahell.
Title: Re: Open Shop v2.0
Post by: Amigamerlin on January 10, 2017, 08:44:35
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
Title: Re: Open Shop v2.0
Post by: datahell on January 10, 2017, 09:56:58
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.
Title: Open Shop v2.0 r64
Post by: datahell on January 13, 2017, 19:25:06
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 (https://www.elxis.net/edc/ecommerce/110.html) 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.
Title: Open Shop v2.1
Post by: datahell on February 06, 2017, 21:16:44
Open Shop updated to version 2.1 (rev70).

In this version:

Download from EDC:
https://www.elxis.net/edc/ecommerce/110.html (https://www.elxis.net/edc/ecommerce/110.html)
Title: Re: Open Shop v2.0
Post by: rentasite on March 02, 2017, 22:18:22

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