Post by StormDesigner » Tue May 10, 2016 11:13 pm

I am looking to do installations of opencart with little likelihood to engage international markets. There is a lot of UI clutter (in admin view) in the sense that while I may only ship to one country, there are hundreds in between me and the one I want to edit. If I remove localized content from the site directory tree (various .php files) prior to upload to a web server I think that might be the way to not have all of the locations and tax info in the admin. Or is removing via the GUI a better practice? In some systems the GUI triggers other actions required or suggested to fully cleanse the system of no longer available resources.

Similar idea applies to various financial gateways and shipping providers in different regions where it can be distracting (possibly risky) to have so many options available. Would save time and upload effort to remove a bunch of php files prior to loading a cart if that works. - thanks OCC.

Running OC 2.0.3.1

O0

StormDesigns, Inc. Website Design and Web Application Development - plus graphic design and print media.

www.StormDesigns.com


User avatar
New member

Posts

Joined
Wed Feb 01, 2012 1:53 am


Post by IP_CAM » Wed May 11, 2016 12:29 am

BTW. This is OC v.1.5.x here! I just hope, you are in no hurry !?
.....
You could remove all not used Languages, in all the sections, where whole bunches of languages are part of, in the INSTALL-, and Javascript- Subsections, usually, and do the same with all those Language PIC's, never used.
-
Then, remove unused Content, related to COUNTRIES, ZONES, Languages, and currencies, from your INSTALL DB, like:

Code: Select all

(1, 'Afghanistan', 'AF', 'AFG', '', 0, 1),
(2, 'Albania', 'AL', 'ALB', '', 0, 1),
(3, 'Algeria', 'DZ', 'DZA', '', 0, 1),
(4, 'American Samoa', 'AS', 'ASM', '', 0, 1),
(5, 'Andorra', 'AD', 'AND', '', 0, 1),
e.t.c.

Code: Select all

(1, 1, 'Badakhshan', 'BDS', 1),
(2, 1, 'Badghis', 'BDG', 1),
(3, 1, 'Baghlan', 'BGL', 1),
(4, 1, 'Balkh', 'BAL', 1),
(5, 1, 'Bamian', 'BAM', 1),
e.t.c.
possibly also some of this Section:

Code: Select all

INSERT INTO `oc_zone_to_geo_zone` (`zone_to_geo_zone_id`, `country_id`, `zone_id`, `geo_zone_id`, `date_added`, `date_modified`) VALUES
(1, 222, 0, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 222, 3513, 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 222, 3514, 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 222, 3515, 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 222, 3516, 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
e.t.c.
JUST LEAVE your Country, Zone, and Language files, by USE of their DEFAULT ID-Numbers, i.E:

Code: Select all

(204, 'Switzerland', 'CH', 'CHE', '', 0, 1),
plus:

Code: Select all

(3095, 204, 'Aargau', 'AG', 1),
(3096, 204, 'Appenzell Ausserrhoden', 'AR', 1),
(3097, 204, 'Appenzell Innerrhoden', 'AI', 1),
(3098, 204, 'Basel-Stadt', 'BS', 1),
(3099, 204, 'Basel-Landschaft', 'BL', 1),
(3100, 204, 'Bern', 'BE', 1),$
e.t.c.
Technically at least. the only remaining problem would be, that the installation routine already contains some Sample- Data, on Products, Countries, Currencies, e.t.c., probably resulting in an install Conflict, if some values do not longer exist, required to finish a working Installation.

I would therefore start, by cleaning out an existing DB, on a server, by use of the MySql-Admin, from Products, Countries, Zones, and so on, then, download it's content, then, change an Install DB, to reflect/match the Content, really used, and so, it would 'shrink' a new DB by about 2'500 never ever used Content-Lines, just standing in the way of others, trying to do an efficient Job. But this would be some work to do, in any case!

Some Extensions exist already, to clean OUT all Demo Data from a running Shop!
But they do NOT Remove any DB-PRESETS, Countries, Zones, e.t.c., like mentioned above, from a DB.

When it comes to FONTAWESOME, (it's heavy on load, and data!) you could 'externalize' it in full, to be called, when used, from another Site. This would also save some Space, and Workload, and later, if everything works, you may work a little on your Header.tpl Linking, and in other Sections, partly by Use of VqMods, to cookie-free externally http-link you Scripts, Stylesheets, and Images. This would then power up the overall Performance to the Peak.

When it comes to unused Payment / Shipping Extensions, most could be removed, from the Theme-, Controller-, Model-, and Language- Subsections, with the Exeption of possibly Amazon and Authorize.net related Stuff. Also, that OpenBay/Ebay Stuff should better not be touched, for some reasons, still unfamiliar to me.

But all this should NEVER be tried by a Coder/DB-NEWBIE, for those, it's much easier to install an OC in the regular way, and later CLEAN OUT a DB, from unused Products, Countries, Zones, e.t.c., by removing those, selectivly, from a Running Shop.

Just, at first, always create a full OC-BACKUP, including the DB, otherways, one possibly has to start from scratch again, if something breaks... :D
And better DO NOT ADD any Mod's, or Themes, anything, before a Cleanout has been done successfully.
And later, check every single Extension, and/or Theme, if it does include anything, just beeing carried as Ballast again, before blindly upload such Extensions to the Server.

To give you some ideas on this... ;)
But it all would make little sense, if you later upload 1+MB Images, they will kill any attempt, to have an efficient Shop.

Ernie

Please don't send me OC Forum Personal Messages, just contact: jti@jacob.ch
---
OC 1.5.6.5 LIGHT Test Site: http://www.bigmax.ch/shop/
OC 1.5.6.5 V-PRO Test Site: http://www.openshop.li/shop/
My Github OC Site: https://github.com/IP-CAM
2'600+ FREE OC Extensions on the World's largest Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by StormDesigner » Wed May 11, 2016 5:13 am

:good:
Awesome response, it sounds like nearly as much work but more file-play risk "unless" someone is doing that on an ongoing basis (once you really know by habit where everything is) but that is a great summary! I'm no noob, maybe a semi-noob in some respects but I can handle what you described above. Thank you so much for the details, I'll definitely review that process.

StormDesigns, Inc. Website Design and Web Application Development - plus graphic design and print media.

www.StormDesigns.com


User avatar
New member

Posts

Joined
Wed Feb 01, 2012 1:53 am


Post by IP_CAM » Wed May 11, 2016 7:48 am

Well, I just don't like to repeat myself, so, my intention is (usually), to 'please' a 'codewise wide gapped' Crowd, in one single step. It may take a little longer, but it only takes once, and if someone cannot follow this, I usually give up afterwards, it then mostly makes not much sence, trying to tell a pinguin, how to fly, just, because it's a bird too :D

But since I invested some time on this already, why not let others know, possibly able to handle it ?! :D
It's not for Newbies anyway, they still have enough other OC-things to learn, to get along with that baby !
Good Luck ! ;)
Ernie

Please don't send me OC Forum Personal Messages, just contact: jti@jacob.ch
---
OC 1.5.6.5 LIGHT Test Site: http://www.bigmax.ch/shop/
OC 1.5.6.5 V-PRO Test Site: http://www.openshop.li/shop/
My Github OC Site: https://github.com/IP-CAM
2'600+ FREE OC Extensions on the World's largest Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland
Who is online

Users browsing this forum: No registered users and 9 guests