Closed

Magento + Google Analytics : change product's position based on GA

Hello, I need someone with good experience in Magento to develop a service to change the sort order in which the products are listed in the category , based on access recorded by Google Analytics and sales of that product .

GOOGLE ANALYTICS

When managing a category in Magento , I can set for each product which position he will appear in that category ( 1st , 2nd ... 50th , etc. ) , but setting it manually is not the best way , the idea is to place the more interesting products first , and so the demand is to create a service to once a week connect to the base of Google Analytics (via API ) , and order the products according to the amount of access they had in the past X days ( configurable parameter ) .

That is, given the initial scenario:

Product A = 0 position

Product B = 0 position

Product C = 0 position

Situation A :

Product B = position 1 ( 150 views)

Product C = position 2 ( 100 views)

Product A = position 3 ( 50 views)

SALES

Sales should also influence this position , then we must consider that each sale (use Magento’s own database) counts as X visits (configurable parameter) to that product also. The sales period to be considered should be a different parameter than the one from Google Analytics, so I may be able to set for instance 90 days of visits and 180 days of sales.

Situation B ( 1 sale = 100 visits ) :

Product C = position 1 ( 100 views + 1 sale)

Product B = position 2 ( 150 views)

Product A = position 3 ( 50 views)

MANUAL INFLUENCE

One last way to influence the position is via manual manipulation . You must create a new attribute for the products , where I may be able to insert positive or negative value , which will serve as an accounting more visits. The idea is to promote or demote products.

Situation C ( 1 sales = 100 visits ) :

Product A = position 1 ( 50 + 500 visits manually )

Product C = position 2 ( 100 views + 1 sale)

Product B = position 3 ( 150 views)

REMARKS

1 - Cancelled sales should not be counted

2 - Should NOT be created a new field for position , should use the existing field of Magento, the service should only change the value of this field.

3 - Every time service runs, must be generated a log file saying that everything ran ok or if there was an error, and which error. And in case of error send an email too.

4 - The service must be scheduled via cron job , but there should also be a manual way to execute it, can be either by an specific URL or a button in the Admin .

5 - The developer should implement it in the test server , and once validated , apply on the production server.

Skills: Google Analytics, Magento, MySQL, PHP

See more: magento google analytics, you on demand, x on demand, time in ga, more visits, job magento developer, google analytics job, google accounting, accounting test for job, accounting test 2, google developer api, api analytics, magento service, Sale product, product test, product a, magento analytics, google analytics api, everything counts, analytics php api, access 2013 insert button, magento create admin, google analytics test magento, change order email, based google api

About the Employer:
( 13 reviews ) São Paulo, Brazil

Project ID: #4964207

29 freelancers are bidding on average $667 for this job

p4provider

Thanks for your invitation , Here are Magento Experts , please check Our Latest Magento work In PMB For Our Experience and skills Regarding Magento projects and Let me start your work , Thanks

$670 USD in 12 days
(109 Reviews)
7.5
themexlx

Please inbox

$750 USD in 18 days
(99 Reviews)
7.5
TeamMagento

Dear Friend,Can do your work impressively,Kindly check our private message,Thanks.

$680 USD in 20 days
(214 Reviews)
7.4
gafprogrammer

Can be well done. Pls check the feedback.

$740 USD in 10 days
(261 Reviews)
7.3
trzwan

Thanks for your invitation, please check PMB for more details.

$1263 USD in 21 days
(177 Reviews)
6.9
ValueCoders

Hello, Ready To Complete this [url removed, login to view] are 60 people company we have around 30 developers for Joomla who are also experts in E-commerce,Drupal,wordpress ,PHP, Zend and Template Designing. [url removed, login to view] 50 [url removed, login to view],CSS , More

$618 USD in 10 days
(105 Reviews)
6.9
zeke

Dear Customer! I am an expert PHP developer with over 6 years of experience and very interested to work on this project. Available to start immediately and finish as soon as possible. My bid is for fast professional s More

$515 USD in 10 days
(159 Reviews)
6.9
dinastalb

Hello, please check our private message. Thank you.

$3789 USD in 30 days
(30 Reviews)
6.6
sainathkohta

Hello Sir, I am from Confianza Technologies. I have gone through your requirements. We have developers who have vast experience in required technologies. We are interested in your project, but before finalizing budget More

$840 USD in 21 days
(36 Reviews)
6.5
kiutisuperking

I can help you do it perfectly. I have more than 4 years work with Magento. Hope we'll work together, thanks!

$789 USD in 12 days
(109 Reviews)
6.2
maxtechsl

Hello, we are ready to implement GA functioanlity to your Magento site as per requirement. Please open message board for further discussion. Regards, Evina.

$600 USD in 7 days
(59 Reviews)
6.1
AndrewSmith22

Hi, I'm interested to work in your project. I'm ready to take up the job now. Please check PM for detail proposal. Thank you.

$447 USD in 7 days
(23 Reviews)
6.0
anirbanbanerjee

we have more than 50 magento running live... we have checked your requirements. we can do it..

$421 USD in 3 days
(43 Reviews)
5.9
vishnulalit

kindly check pmb for the and ready to start immediate

$1263 USD in 30 days
(19 Reviews)
5.8
bistanil98

I have check this requirement,have some query,so need to discuss this,please tell me how we can start the discussion. to know more about us please check Private Message. We have a team of professionals,they have more More

$550 USD in 17 days
(16 Reviews)
5.5
posspooja

glad to work with you

$824 USD in 18 days
(31 Reviews)
5.5
virals2583

Hello, I got your requirement about products ordering in different criteria and do believe we can write this script for your Magento store. Please check the PM for more details. Thanks - Nirav Shah

$722 USD in 15 days
(15 Reviews)
5.4
VnBestSolutions

Dear Sir, We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! More

$777 USD in 10 days
(32 Reviews)
5.3
scientificwebs

We believe good design is like good manners, you just simply have it and you do not need to prove it. You might not find us on Award lists and we do not aim to get any award. Our award = superb result = happy client. W More

$773 USD in 10 days
(18 Reviews)
5.5
technovation1

i ready start now

$250 USD in 2 days
(28 Reviews)
5.1