Get a Freelance Job

“The query should permit the user to specify an account number separately from the query.”
- This means “Stored Procedure”. Right ? Please confirm from your supervisor.

“When the query runs, the results window should display the account number, description and balance.”

We are a company that sells electric scooters online. We have a rather vast custom built affiliate marketplace that I am migrating to a Joomla + Virtuemart + VM Shopbuilder solution.

The objective of this job is to extend the functionality of a Joomla component called VM Shopbuilder. VM Shopbuilder allows you to easily import affiliate datafeeds directly into Virtuemart and also search the Commission Junction database through their API.

We are looking for extended functionality similar to the existing Comission Junction interface, basically duplicating the Commission Junction API feature, but interfaces with Amazon’s API.

Here is a breakdown of what we are looking for:

Amazon API Interface:

1. The ability to build a search query based on one or more of the following variables: keywords, distributor, category, brand, high price, low price, and sku

2. Search results must have the ability to be sorted by: name, price, distributor, brand, and sku

3. Ability to create a new Virtuemart category on the fly to assign the results to as well as the ability to assign the query results to an existing Virtuemart category. (identical to existing CJ interface)

4. Query results are then stored in the VM Shopbuilder “Import Manager” before giving the user the option to add all or just the selected items to the Virtuemart catalog.

5. Items can be removed from Virtuemart and will be sent back to the VM Shopbuilder Import Manager.

Automation Features (create a VM Shopbuilder section that allows us to set these parameters and view/edit our search filters):

5. All CJ and Amazon search queries must be able to be saved and cataloged for later use.

6. Ability to construct and save search query filters that will allow us to flag and remove certain items from the search results. That way the next time we run the query we don’t have to sort through 10,000 product entries.

7. Ability to run all saved search queries via a cron task.

8. Ability to identify new products in a search result, flag them, and notify web administrator via email. Must be able to filter new products out of the query results from VM Shopbuilder backend.

9. Extend these automation features to the existing Commission Junction interface already in place.

Additionally:

10. Extended product description functionality that will allow us to append a custom description to any item, assign that description to the item and store it in the database. This will be applied to ALL items that are imported with the VM Shopbuilder component, allowing us to maintain our custom description information after any automated product updates or modifications.

Please e-mail us with any questions-
Thanks!

I’ve tried everything to write this query myself with no luck, so I’m giving up and hoping that a professional here can write it for me. I will deposit funds for the winning bidder into escrow and release them for you when I see that the query works. Or if you don’t want escrow, I will pay when the project is complete and the query works. I need to get this query as soon as possible, so this will be a quick auction. Hopefully it won’t take a professional db developer very long to write it, as I would think this is actually a common task. Here is what I need:

The database I use is MySQL 5 (my application is in PHP 5). My application stores multiple payment amounts paid by different customers to different companies. Assume that each customer

I have two tables with the following structure:

PRODUCTS
id
productname
qty1
qty2
qty3

OPTIONS
id
productid
optionname
qty1price
qty2price
qty3price

I know that the database is not as efficient as it could be, but that is not what the project is for. You are just to get the query to work with the current database structure.

With that being said, the object is for you to allow these fields to be edited through a page called update.php

The current update.php page takes the variable “id” from the URL and pulls from the PRODUCTS table all rows where the id is equal to the id in the URL. It also pulls information from OPTION where the productid is equal to the id in the URL. All of this information is then summarized in an an HTML table.

Headings: QTY1, QTY2, QTY3
Row 1: OPTIONNAME1, QTY1PRICE, QTY2PRICE, QTY3PRICE
Row 2: OPTIONNAME2, QTY1PRICE, QTY2PRICE, QTY3PRICE

These results are displayed in input fields so that they can be edited. The problem that I have with the current update.php file is that there can be multiple OPTIONS for a single product, so right now, the query is only updating one OPTION for each product. I’m sure that I’m just missing a loop or for each statement-something simple. I’d like you to write the code for the input fields/form. I have most of the fields, but I may be missing something like a hidden field, which will cause the query to work. You also need to write the query that will update both pages. The form needs to submit using the post method, not the get method.

Only bid if you can have it finished in one hour. Lower bids with faster delivery have priority.

I have two tables with the following structure:

PRODUCTS
id
productname
qty1
qty2
qty3

OPTIONS
id
productid
optionname
qty1price
qty2price
qty3price

I know that the database is not as efficient as it could be, but that is not what the project is for. You are just to get the query to work with the current database structure.

With that being said, the object is for you to allow these fields to be edited through a page called update.php

The current update.php page takes the variable “id” from the URL and pulls from the PRODUCTS table all rows where the id is equal to the id in the URL. It also pulls information from OPTION where the productid is equal to the id in the URL. All of this information is then summarized in an an HTML table.

Headings: QTY1, QTY2, QTY3
Row 1: OPTIONNAME1, QTY1PRICE, QTY2PRICE, QTY3PRICE
Row 2: OPTIONNAME2, QTY1PRICE, QTY2PRICE, QTY3PRICE

These results are displayed in input fields so that they can be edited. The problem that I have with the current update.php file is that there can be multiple OPTIONS for a single product, so right now, the query is only updating one OPTION for each product. I’m sure that I’m just missing a loop or for each statement-something simple. I’d like you to write the code for the input fields/form. I have most of the fields, but I may be missing something like a hidden field, which will cause the query to work. You also need to write the query that will update both pages.

I will not be able to answer questions, because I will not be here. I think that I have provided enough information for you to work independently. Once I get back in within four hours, I will select someone. Include the phrase not a bot in your bid, or it will not be considered at all-even if you only bid $10. I’m only looking for this project to be completed, so no portfolios or background information about you or your company. If you have a demo for this project, post it in the PMB.

Thanks.

Hi,

I need a simple php/SQL query writing.

I run a oscommerce store. Every now and again need to delete some entrys (any adress book id tha is 0)from the customer address book table of the database.

I find it a pain going in to PHP my admin to do this each time.

I would like a bit of code writing so I can just press a button from within my admin to execute/run the query and delete the entrys required.

I think the sql query would be something like this

DELETE FROM ‘address_book’WHERE ‘address_book_id’ =0 LIMIT 0

I dont mind either a button on the admin page to run the query or calling a given URL that will run the query.

Ok, Here is the skinny:

We have a rather vast custom built affiliate marketplace that I am migrating to a Joomla + Virtuemart + VM Shopbuilder solution.

The objective of this job is to extend the functionality of a Joomla component called VM Shopbuilder. VM Shopbuilder allows you to easily import affiliate datafeeds directly into Virtuemart and also search the Commission Junction database through their API.

We are looking for a similar functionality, basically duplicating the Commission Junction API feature, that interfaces with Amazon’s API.

Here is a breakdown of what we are looking for:

Amazon API Interface:

1. The ability to build a search query based on one or more of the following variables: keywords, distributor, category, brand, high price, low price, and sku

2. Search results must have the ability to be sorted by: name, price, distributor, brand, and sku

3. Ability to create a new Virtuemart category on the fly to assign the results to as well as the ability to assign the query results to an existing Virtuemart category. (identical to existing CJ interface)

4. Query results are then stored in the VM Shopbuilder “Import Manager” before giving the user the option to add all or just the selected items to the Virtuemart catalog.

Automation Features:

5. All CJ and Amazon search queries must be able to be saved and cataloged for later use.

6. Ability to construct and save search query filters that will allow us to flag and remove certain items from the search results. That way the next time we run the query we don’t have to sort through 10,000 product entries.

7. Ability to run all saved search queries via a cron task.

8. Ability to identify new products in a search result, flag them, and notify web administrator via email. Must be able to filter new products out of the query results from VM Shopbuilder backend.

9. Extend these automation features to the existing Commission Junction interface already in place.

Additionally:

10. Extended product description functionality that will allow us to append a custom description to any item, assign that description to the item and store it in the database. This will be applied to ALL items that are imported with the VM Shopbuilder component, allowing us to maintain our custom description information after any automated product updates or modifications.

Please send me a brief message stating your experience working with Joomla and the Amazon and Commission Junction API system.

I want to create a dynamic banner.

The first layer will be the background that is a real, premade, static image that has our company’s name on it.

The second layer is an image that we will grab from our server. The image location/name will be determined by the query string. If the query string is ?image=imagenumber123, then the image that will be pulled and displayed is imagenumber123.png.

The the next layer is dynamic text that will be written on the background/first layer. This text will be determined by the query string. So, if the query string is ?text=some random text, then “some random text” has to be written on the background.

All of this has to be saved as an image. I have done most of it already. I learned how to do it within minutes, but since I’m new to it, cannot get all three layers merged. Hopefully, someone with more experience and who knows how easy it is, will do this and not charge too much. Thanks, and I will select someone in a few hours. If you have a demo, please provide one. I provide 100% escrow.

Hello Everyone -

I am a working freelance web developer myself and will be working directly with the bid winner to complete this project.

Here is the skinny:

The objective of this job is to extend the functionality of a Joomla component called VM Shopbuilder. VM Shopbuilder allows you to easily import affiliate datafeeds directly into Virtuemart and also search the Commission Junction database through their API.

We are looking for a similar functionality, basically duplicating the Commission Junction API feature, that interfaces with Amazon’s API.

Here is a breakdown of what we are looking for:

1. The ability to build a search query based on one or more of the following variables: keywords, distributor, category, brand, high price, low price, and sku

2. The search query must be able to be saved and cataloged for later use.

3. Search results must have the ability to be sorted by: name, price, distributor, brand, and sku

4. Ability to create a new Virtuemart category on the fly to assign the results to as well as the ability to assign the query results to an existing Virtuemart category. (identical to existing CJ interface)

5. Ability to construct and save search query filters that will allow us to flag and remove certain items from the search results. That way the next time we run the query we don’t have to sort through 10,000 product entries.

6. Ability to run all saved search queries via a cron task.

7. Ability to identify new products in a search result, flag them, and notify web administrator via email. Must be able to filter new products out of the query results from VM Shopbuilder backend.

Any questions?
Happy bidding!

I need a php script to parse data from results of search requests similar to this:

http://www.popshops.com/v1/0yp0rj3hqei08nztbslkxco1m/products.xml?catalog_key=8dma5bktzb9bseed24byo2z3w&keywords=ipod+16gb

The results will then be displayed on our online shopping mall website (www.ShoppingMinistry.com). It should display a list of available products and allow customer to sort by name, price etc. It should also allow them to narrow the search by available parameters.

Here are more info about available parameters etc:

Request URL

http://www.popshops.com/v1/0yp0rj3hqei08nztbslkxco1m/products.xml
Required request parameters
Field Value Description
catalog_key string Unique key identifying catalog of merchants: 8dma5bktzb9bseed24byo2z3w
keywords string

A list of keywords to search across your catalog merchants.

keywords=ipod Is a basic search for products containing the keyword ‘ipod’

keywords=ipod -case is a search for products containing the keyword ‘ipod’ and NOT containing the keyword ‘case’
Optional request parameters
Field Value Description
merchant_id integer A unique PopShops merchant_id, limiting products to a single merchant
merchant_type_id integer A unique merchant_type_id limiting products to a single merchant_type.
category_id integer A PopShops category ID, limiting products to a single merchant’s category. Category ids are currently only returned in product query responses.
brand_id integer A PopShops brand_id, limiting products to a single brand
price_min decimal
10.00,19.95, etc
Price minimum product prices should not go below
price_max decimal
10.00,19.95, etc.
Price maximum product prices should not exceed
product_sort name_asc
name_desc
price_asc
price_desc Featured (default), Name (A-Z), Name (Z-A), Lowest Price, Highest Price
product_limit 1-100 Number of products to display at a time. 100 maximum.
product_offset integer Number to offset the product results by
include_deals boolean
1 or 0
Available deals can also be included in the result set that match returned products and merchants.
url_subid string Custom subid/sid to be appended in any final affiliate product urls.
Response fields
Field Description
search_results Contains all of the query responses. Attributes:

* keywords: any keywords passed in
* product_limit: any product_limit passed in
* product_offset: any product_offset passed in
* merchant_id: any merchant_id passed in
* category_id: any category_id passed in
* brand_id: any brand_id passed in
* product_sort: any product_sort passed in
* price_min: any price_min passed in
* price_max: any price_max passed in
* merchant_type_id: any merchant_type_id passed in

products Contains products matching the query parameters. Attributes:

* total_count: Total number of products matching the query parameters

product Contains an individual product. Attributes:

* name: The name of the product
* description: The description of the product
* merchant_id: The merchant_id for the merchant the product belongs to.
* large_image_url: A url for the largest sized image available for the product.
* medium_image_url: A url for a medium sized image of the product.
* small_image_url: A url for a small sized image of the product.
* merchant_price: The price offered through the merchant. Usually corresponds to the lowest price.
* retail_price: The listed retail price of the product.

price_ranges Contains price_ranges for products matching the query parameters.
price_range Contains an individual price_range. Attributes:

* max: The max dollar value in the range
* min: The min dollar value in the range
* product_count: The number of products within this price range.

merchants Contains top merchants for products matching the query parameters. In many cases the number of merchants matching the query is too many to bring back, so this will only bring back the top 50 merchant matches by product count. You may encounter results where you get a product on a page and there is no matching merchant in the merchants node.
merchant Contains an individual merchant. Attributes:

* id: A unique id for the merchant. You can pass this in as a merchant_id to filter products to this specific merchant.
* name: The name of the merchant.
* product_count: The number of products matching the query for this specific merchant.
* logo_url: If available a logo_url will be provided which is a url to small thumbnail of a logo for the merchant.
* url: If available the url will be returned, which is a landing page for this merchant.
* merchant_type_id: If the merchant belongs to a merchant_type, this will be the id for the merchant_type. This can be used to further filter products as a merchant_type_id parameter.

merchant_types Contains top merchant_types for products matching the query parameters.
merchant_type Contains an individual merchant_type. Attributes:

* id: A unique id for the merchant_type. You can pass this in as a merchant_type_id to filter products to this specific merchant_type.
* name: The name of the merchant_type.
* product_count: The number of products matching the query for this specific merchant_type.

brands Contains top brands for products matching the query parameters.
brand Contains an individual brand. Attributes:

* id: A unique id for the brand. You can pass this in as a brand_id to filter products to this specific merchant_type.
* name: The name of the brand.
* product_count: The number of products matching the query for this specific brand.

suggested_merchants If the keywords match any merchant names, or have been tagged by PopShops as belonging to a specific merchant, this node will return any merchants that may be possible matches. This node will have child merchant nodes with attributes available on normal merchant nodes.
deals Contains deals available for products,merchants, and suggested merchants matching the query. Attributes:

* restrictions: Global restrictions that apply to any deal returned.

deal Contains an individual deal. Attributes:

* name: The name of the deal.
* description: A description of the deal.
* url: The redirect url for the deal.
* image_url: If an image is available for the deal, this will be a url for that image.
* specific: This is a boolean (true/false) indicating whether the deal is specific to a product, or applies to all products from the merchant.
* start_on: The start date the deal is valid.
* end_on: The end date the deal is no longer valid.
* code: Any associated code for the deal. This is a code that would need to be used to redeem the deal.
* deal_type_ids: The deal_type id indicating what kind of deal this is.
* restrictions: Any applicable restrictions unique to this deal or merchant.
* merchant_id: A unique id for the merchant.
* merchant_type_id: The id of the merchant_type the merchant of this deal belongs to.