Closed

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

This project received 35 bids from talented freelancers with an average bid price of $765 USD.

Get free quotes for a project like this
Employer working
Project Budget
$250 - $750 USD
Total Bids
35
Project Description

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 Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online