#rapnet

RapNet Launches Upgraded Trading Platform

January 8, 2018, Las Vegas

RapNet, the world’s leading diamond trading network, will launch a new, upgraded platform tomorrow, January 9, 2018. The upgrade will provide members with a more secure, intuitive and smarter trading environment. It is the first step in a $5 million Rapaport and RapNet development project that will revolutionize the electronic…

Namjoon : *open the door* “After you my lady”

Seokjin : *smile at you* “Tell me i’m handsome first then i’ll open it for you”

Yoongi : *open the door for you* *quietly get in the car*

Hoseok : *steal a kiss on your lips* “Whoopie got my present, get in”

Jimin : *smirk* “You want me to open the door for you right?”

Taehyung : *smile goofyly* “I forgot the key, lets just walk”

If you are a B2B diamond trading company or a diamond dealer; you should have your own diamond trading platform . You can list your inventory with mark-ups and have your sub-dealers as its members.

The platform comes with:

· Responsive website

· Android and IOS app

Demo is available on:

http://diamonddealer.transpacific-software.com/

For backend admin walk-through contact us on [email protected]

Features :

1) Ability to add/ remove sub-dealers with individual mark-ups

2) Full integration with Rapnet/IDEX/Custom diamond feed

3) Blazing fast diamond search Engine

4) Custom built Android /IOS version APP of the site

5) Ability to put different markup for different users

6) Site is fully responsive

2) Built on Opencart e-commerce framework

3) Customization and Branding of the Platform

Many  jewelry web-sites developed on Woocommerce ( A WordPress e-commerce  plugin) require  integrating diamond data from diamond trading exchanges like Rapnet , IDEX, MID or Polygon.

Unlike Magento Opencart or Prestashop which are built ground up for e-commerce,  Woocommerce is a plugin on WordPress blog framework ,  to  improvise it to ecommerce store.

 Essentially the “posts” in WP are altered by woocommerce to show as items/products, this makes it restrictive for customization. Furthermore  for massive diamond trading  data (typically Rapnet feed may go into 50,000+ diamonds) with numerous diamond specific attributes like carat weight, color, fluorescence, clarity, cut etc; integration becomes complex.

As a specialist in Diamond Jewelry websites ; Transpacific regularly receives project requests to integrate Woocommerce or WP-ecommerce with Rapnet data as well  as to build front end diamond search interface for build a ring feature.

The biggest problem:  Inserting bulk (more than 100k)records in Woocommerce-WP

How is it done:

a)  Prepare the database  to handle additional diamond attributes

 CSV format Diamond data is downloaded from trading exchanges like Rapnet/IDEX/ Polygon or MID.

Unlike a other products a diamond has many specialized attributes including cut, Florescence, table , symmetry etc.  all these  are  necessary for creating front end “diamond search engine”

So the first step to prepare database, is by creating additional tables for diamond specific attributes to be joining to posts table with “post ID

b)CSV parsing and inserting extensions

WP has few good quality extensions available for  CSV import . However most of them could  not go beyond inserting 10k+ products.

During our testing all of these flashed

“Fatal error: Allowed memory size Exhausted”

 error .

This happens due to WP native data insert functions to insert product data including      wp_insert_post();

-      wp_set_object_terms();

-      add_post_meta();

-      update_post_meta();

Consume extensive server memory ; by the time they reach 8K-10K product inserts “memory exhausted error shows up”

Out-of-Box approach for 100K CSV data insert

An out of box approach had to be taken for inserting 100K products by developing a separate custom plugin  which parsed the csv files through Core PHP queries .TransPacific’s  specialized module efficiently inserts about 100K product records in about 17-20 minutes.

Front end diamond search engine:

Front end Diamond search engines forms an integral part of the Diamond web-site. A spate WP plugin had to be built for diamond search which queries more than 100,000 diamond records on more than 10 filtering criterions.

A demo is available on  http://www.techtps.com/woo/?post_type=loosediamonds